Re: [GENERAL] Postgres logs showing error after replication

2017-09-06 Thread Vick Khera
On Wed, Sep 6, 2017 at 1:16 AM, Vijay Chaudhery wrote: > Ok is it possible to release the lock? or it is just a warning messages > only? > thanks > The message starts with "ERROR" so it is an error, not a warning. The command failed. The only way to release the lock is to have the other connecti

Re: [GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Vijay Chaudhery
Ok is it possible to release the lock? or it is just a warning messages only? thanks -Original Message- From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] Sent: 06 September 2017 10:31 AM To: Vijay Chaudhery Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres logs showing error

Re: [GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Tatsuo Ishii
> Ok thank you, > > I have promoted slave server as master in postgres streaming replication , > howerver application is working fine after promotion , but getting some error > messages in the postgres log (slave which promoted to master) > > what does it mean? > > >>ERROR: could not obtain

Re: [GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Vijay Chaudhery
t;."modified", "main_instance"."version", "main_instance"."capacity" FROM "main_instance" LIMIT 1 FOR UPDATE NOWAIT -----Original Message----- From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] Sent: 06 September 2017 10:02 AM To: Vijay Chaud

Re: [GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Tatsuo Ishii
> I am not sure if the sending email is the right way to get the forum help. > Could you please let me know how to open forum query to ask postgres > questions. Sending email to this mailing list regarding your questions is the perfect way to get help. Other than this, there's an IRC channel fo