Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

On 22 December 2017 19:53:03 CET, hmidi slim wrote: >Hi, >I don't know if is it the suitable place to ask my question but I want >to >know if a table in a postgres database enable multiple reading actions >for >mayn rxjs observbles or not. Not sure if i understand your question. But for sure PG i

Re: Array of foreign key

On 22 December 2017 20:02:43 CET, Thomas Poty wrote: >Hello all, > >I use postgresql 9.5 and I am looking for way to have a column which is >an >array of a foreign key. If what I read is correct it is currently not >possible... Have you any idea how to implement this feature in a safe >way Normal

Re: Array of foreign key

>Please DO NOT use EMUMs. That is old. They are hard to maintain. I also >know from experience that MySql does not check >integrity of enums. It's possible you can have data in a MySql table >column >that is not valid for current enum constraint on that column. >EG: When porting, the enum for a co

Re: Scheme conversion MySQL to PGSQL

On 24 December 2017 18:52:39 CET, Michelle Konzack wrote: >Hello * > >I try to convert a Database scheme from mySQL to pgSQL and have >problems with the line: > > KEY post_date (post_date) > >and later probably with the lines > > UNIQUE KEY user (stat_login) >and > KEY forum

Re: Use of Port 5433 with Postgresql 9.6

On 1 January 2018 18:42:28 CET, Graeme wrote: >If the default port for v9.6 is 5433, why does the utility pg_isready >still default to searching for 5432? The default port for PostgreSQL is 5432. You can use option -p or --port to specify an other Port. You can also set Environment-varibles, pl

Re: Setting up streaming replication problems

Am 22.01.2018 um 07:39 schrieb Thiemo Kellner: Hi all I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have two clusters main (master) and main2 (hot standby). I tried wi

Re: FW: Setting up streaming replication problems

Hi, Am 29.01.2018 um 06:03 schrieb Thiemo Kellner: Thanks for your patience. you are welcome. From the other mail (in german) i think i know the issue now: you have placed the recovery.conf NOT in the data_directoy but in /etc/... PostgreSQL is looking for the recovery.conf in the data_d

Re: Master-Slave error: the database system is starting up

Am 01.02.2018 um 15:43 schrieb Сергей Злобин: Hello, I was advised to write a letter to you Windows Server 2012 Postgres 9.6 I made a replication with the master server. On the slave server service postgres is running, but in log files slave's server "FATAL:  the database system is starting u

Re: Parallel Query - Can it be used within functions?

Hi, Am 06.02.2018 um 08:24 schrieb Michael Krüger: create or replace function reports.generic_query(_sql text)   RETURNS SETOF record   LANGUAGE 'plpgsql'   PARALLEL SAFE   COST 100 there is an other parameter, parallel_setup_cost, with default = 1000. I think, you should set this parameter

Re: PostgreSQL Active-Active

Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam: Hi Gurus, Do we have active-active setup in postgreSQL, like we have in oracle RAC?. Sorry if this question has been addressed already. What will be best open source HA for postgresql with zero RTO and RPO. -D we have BDR, but this isn

Re: execute block like Firebird does

Am 11.02.2018 um 06:57 schrieb PegoraroF10: We are migrating our databases from Firebird to PostGres. A useful feature Firebird has is Execute Block. What it does is just return a record set from that dynamic SQL, just like a PostGres function, but without creating it. It sound like ... execute

Re: postgres connection with port option in shell script

Am 14.02.2018 um 16:21 schrieb Abhra Kar: Hi,       I want to get postgres connection in script file. I am executing below command and successfully getting connected --- psql postgresql://$USER:$PASSWORD@$HOST/$DATABASE

Re: postgres started without auto vaccum

On 16 February 2018 06:54:43 CET, Azimuddin Mohammed wrote: >Hello All, >I am getting below Warning messages in logs after starting postgres, >can >some please help me here > >LOG: could not bind socket for statistics collector: Cannot assign >requested address > >LOG: disabling statistics collect

Re: postgres started without auto vaccum

Am 16.02.2018 um 07:23 schrieb Azimuddin Mohammed: Its on rhel 7.3 , i cant disable firewal, its on one of my company dev server. On Feb 16, 2018 12:21 AM, "Andreas Kretschmer" mailto:andr...@a-kretschmer.de>> wrote: On 16 February 2018 06:54:43 CET, Azimuddin Mohammed

Re: pg_update to a new machine?

Am 24.02.2018 um 04:57 schrieb Ron Johnson: The 2.8TB database must be moved to a new server in a new Data Center, and upgraded from 8.4.17 to 9.6.6 Will this work? pg_upgrade --old-datadir "CURSERVER://var/lib/pgsql/data" --new-datadir "NEWSERVER://var/lib/pgsql/data"

<    1   2   3