[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-07-18 Thread sudalai
Got it. Thank you very much. :) -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5912426.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent

[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-07-18 Thread sudalai
thank u. why (select * from pg_logical_slot_peek_changes('slot',NULL,1) ) take share lock ? any idea ? -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5912411.html

[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-07-18 Thread sudalai
gin takes share lock ? Is there any way i can avoid it? Please help me. -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5912389.html Sent from the PostgreSQL - general

[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-06-23 Thread sudalai
Thank u. The problem is because of the commented line. I forgot about that. Now, I uncommented it. It working fine. Thank u very much. -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical

[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-06-23 Thread sudalai
is logical_decoder code: rep_slot.c <http://postgresql.nabble.com/file/n5909207/rep_slot.c> Thanks in Advance. -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194p5909207.html Sen

[GENERAL] Re: ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-06-23 Thread sudalai
Hi john, PostgreSQL 9.5.0 has bug !!!, Does 9.5.0 remove unconsumed toast rows need for slot?? It is fixed in latest!!!. -Sudalai - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder

[GENERAL] ERROR: missing chunk number 0 for toast value while using logical decoder.\

2016-06-23 Thread sudalai
Thanks In Advance. - sudalai -- View this message in context: http://postgresql.nabble.com/ERROR-missing-chunk-number-0-for-toast-value-while-using-logical-decoder-tp5909194.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Change recovery configuration without restarting standby_node.

2014-10-27 Thread sudalai
How to change the* recovery configuration *such as *master ip, primary_conninfo* without restarting the standby node in postgresql. - sudalai -- View this message in context: http://postgresql.1045698.n5.nabble.com/Change-recovery-configuration-without-restarting-standby-node-tp5824432