Re: [GENERAL] Streaming replication stacked.
Hi Michael , Thank you for your information!! I understand. I'll consider to upgrade to 9.4.5. I'm grateful for all your support. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880550.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Streaming replication stacked.
Hi Andreas and Michael, Thank you for your information! Let me know, which should I choose update to 9.4.5 or hot_standby_feedback off? Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880487.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Streaming replication stacked.
Hi Michael, Thank you for replying. I'm using version of 9.4.3. And I have seen same behavior on version of 9.3.4. Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880329.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Streaming replication stacked.
Hi, Andreas Thank you for replying. You're right, I have only 1 slave. And I need running transactions on slave. Once I restarted postgres service on slave and then process began to move. Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880326.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Streaming replication stacked.
Hi Chiru , Thank you for your information. I send wals to standby server using "wal sender" processes. And I had checked logs but It was nothing. Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880288.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Streaming replication stacked.
Hi, Andreas Thank you for reply. Below is the recovery.conf. -- standby_mode = on primary_conninfo = 'host=172.16.xxx.xxx user=xx' trigger_file = '/tmp/trigger_file0' ------ Best regards. Yoji -- View this message in context: http://postgresql.nabble.com/Streaming-replication-stacked-tp5880104p5880287.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general