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

Re: [GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Vijay Chaudhery
stgres logs showing error after replication > 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 t

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: Vija

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

[GENERAL] Postgres logs showing error after replication

2017-09-05 Thread Vijay Chaudhery
Hi, 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. Thanks vijay ::DISCLAIMER::