Re: A query in Streaming Replication

2020-06-14 Thread Sreerama Manoj
Hello, Can anyone check this and respond please!! Thanks and regards, Manoj. On Sat, Jun 13, 2020, 20:26 Sreerama Manoj wrote: > Hello, > I use streaming replication in async mode. When master gets down, > slave will be promoted using a trigger file. During this process ".part

Re: Unable to execute pg_dump

2020-06-14 Thread Tom Lane
Joseph Maruca writes: > I end up in the bash-4.1 shell. When executing the following command from > within the shell: bash-4.1$ pg_dump db_name > /tmp/my_database.sql I am > presented with the following error: > pg_dump: [archiver (db)] connection to database "db_name" failed: could not > conn

Re: Unable to execute pg_dump

2020-06-14 Thread David G. Johnston
On Sunday, June 14, 2020, Joseph Maruca wrote: > > '''sudo -u postgres -H --psql -px -d db_name''' > > If I enter the following syntax from the RHEL command line: > > '''sudo su postgres''' > > I end up in the bash-4.1 shell. When executing the following command from > within the shell: bash-4

Unable to execute pg_dump

2020-06-14 Thread Joseph Maruca
Hello everyone, I am trying to work out a way to perform a PostgreSQL pg_dump of a single DB via RHEL v6.10 command line. Now the system I am working on is that you have to shell into Bash 4.1 first before you get to PSQL. Now I can access the actual PSQL db using the following syntax from the

Re: pg_service.conf and client support

2020-06-14 Thread Adrian Klaver
On 6/13/20 10:03 PM, Niels Jespersen wrote: Hello all I just found out about the pg service file. https://www.postgresql.org/docs/current/libpq-pgservice.html I don’t know why it took me so long finding this. I have been looking for ways to abstract physical details of data location away for

Re: BUG #11141: Duplicate primary key values corruption

2020-06-14 Thread Adrian Klaver
On 6/14/20 12:17 AM, Abraham, Danny wrote: Hi, PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates when in stress and many concurrent threads updating. Is it BUG #11141 ( Duplicate primary key values corruption ). ? Anyone aware of a resolution for this ? According to the

Re: Oracle vs. PostgreSQL - a comment

2020-06-14 Thread Bruce Momjian
On Sat, Jun 13, 2020 at 09:27:25PM -0400, Bruce Momjian wrote: > On Sat, Jun 13, 2020 at 05:06:37PM -0500, Ron wrote: > > On 6/13/20 1:46 PM, Bruce Momjian wrote: > > > On Wed, Jun 3, 2020 at 08:53:45PM +0200, Andreas Joseph Krogh wrote: > > > > I agree these are all technical issues, but neverthe

Re: Something else about Redo Logs disappearing

2020-06-14 Thread Magnus Hagander
On Sat, Jun 13, 2020 at 10:13 PM Peter wrote: > On Thu, Jun 11, 2020 at 10:35:13PM +0200, Magnus Hagander wrote: > ! > Okay. So lets behave like professional people and figure how that > ! > can be achieved: > ! > At first, we drop that WAL requirement, because with WAL archiving > ! > it is alre

Re: BUG #11141: Duplicate primary key values corruption

2020-06-14 Thread Ron
9.5.5 is pretty old.  I'd strongly think about updating to one of the *seventeen* subsequent patch releases. https://www.postgresql.org/docs/release/9.5.22/ On 6/14/20 2:17 AM, Abraham, Danny wrote: Hi, PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates when in stress and m

BUG #11141: Duplicate primary key values corruption

2020-06-14 Thread Abraham, Danny
Hi, PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates when in stress and many concurrent threads updating. Is it BUG #11141 ( Duplicate primary key values corruption ). ? Anyone aware of a resolution for this ? B.T.W - Looks like it happens less on Linux. Thanks Danny