Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"

2020-07-16 Thread Naresh Kumar
Thanks, I will check it out. On Fri 17 Jul, 2020, 7:42 AM Christophe Pettus > > > On Jul 16, 2020, at 19:08, Naresh Kumar wrote: > > > > Thanks Christopher, if you any such contacts can you share with us. > > The community maintains this page; I'm sure you can find someone who can > help you

Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"

2020-07-16 Thread Christophe Pettus
> On Jul 16, 2020, at 19:08, Naresh Kumar wrote: > > Thanks Christopher, if you any such contacts can you share with us. The community maintains this page; I'm sure you can find someone who can help you there: https://www.postgresql.org/support/professional_support/ -- --

Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"

2020-07-16 Thread Naresh Kumar
Thanks Christopher, if you any such contacts can you share with us. Regards, Narresh On Fri 17 Jul, 2020, 7:04 AM Christophe Pettus > > > On Jul 16, 2020, at 18:32, Naresh Kumar wrote: > > > > Can some one help us on this please. > > To be clear, what you almost certainly have here is serious

Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"

2020-07-16 Thread Christophe Pettus
> On Jul 16, 2020, at 18:32, Naresh Kumar wrote: > > Can some one help us on this please. To be clear, what you almost certainly have here is serious data corruption. You will need to find a (paid, commercial) specialist to help you with the recovery. You are unlikely to get the level of

Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index"

2020-07-16 Thread Naresh Kumar
Yes Karsten, Can some one help us on this please. Regards, Narresh On Wed 15 Jul, 2020, 10:55 PM Karsten Hilbert On Wed, Jul 15, 2020 at 10:03:06PM +0530, Naresh Kumar wrote: > > > Already I tried to connect with template0, template1, user database name, > > postgres, nothing is working

Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?

2020-07-16 Thread David G. Johnston
On Thu, Jul 16, 2020 at 1:24 PM Adrian Klaver wrote: > On 7/16/20 1:17 PM, Devraj B wrote: > > Please reply to list also. > Ccing list. > > Thanks Adrian, > > > > I had granted LOGIN to PostgreSQL user firstname.lastname but do Not > > want to provide a database password, > > rather I wanna

Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?

2020-07-16 Thread Adrian Klaver
On 7/16/20 1:17 PM, Devraj B wrote: Please reply to list also. Ccing list. Thanks Adrian, I had granted LOGIN to  PostgreSQL user  firstname.lastname but do Not want to provide a database password, rather I wanna access the database using my JumpCloud password directly from my Macbook Pro

Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?

2020-07-16 Thread Adrian Klaver
On 7/16/20 12:04 PM, Devraj B wrote: I login to my Macbook Pro using my JumpCloud password. My userid is firstname.lastname /Users/firstname.lastname > whoami firstname.lastname After connecting to VPN, from my Macbook Pro Terminal, I connect to PostgreSQL server staging.mycompany.com

Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?

2020-07-16 Thread Devraj B
I login to my Macbook Pro using my JumpCloud password. My userid is firstname.lastname /Users/firstname.lastname > whoami firstname.lastname After connecting to VPN, from my Macbook Pro Terminal, I connect to PostgreSQL server staging.mycompany.com having CentOS 6.10 /Users/firstname.lastname >

Capturing just slow queries

2020-07-16 Thread Tiffany Thang
Hi, log_min_duration_statement captures all statements including DMLs that have exceeded the threshold. Is there a way in PG 12 to capture just select statements excluding all DMLs and DDLs? In my environment, it's acceptable for DMLs and DDLs to cross the threshold and we are more interested in

Re: Clustering solution ?

2020-07-16 Thread Jehan-Guillaume de Rorthais
On Wed, 15 Jul 2020 15:54:03 + (UTC) Laurent FAILLIE wrote: > Hello all, > thanks all for your replies : I started to learn Patroni.Anyway, any > alternative with my customer want's also LoadBalancing ? Thanks > Laurent Same comment than my previous one here. Climb one step at a time.

Re: Efficiently advancing a sequence without risking it going backwards.

2020-07-16 Thread Paul McGarry
On Fri, 10 Jul 2020 at 10:27, Jeremy Schneider wrote: > > OP asked for a way to call setval() with a guarantee the sequence will > never go backwards IIUC. His code can check that the new value he wants to > set is higher than the current value, but there’s a race condition where a > second