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
On Wed, Jan 6, 2016 at 9:27 AM, Yoji wrote:
> Hi Andreas and Michael,
>
> Thank you for your information!
>
> Let me know, which should I choose update to 9.4.5
Updating to 9.4.5 is highly recommended, and a separate issue.
> or hot_standby_feedback off?
Switching hot_standby_feedback to off de
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 Postg
Michael Paquier wrote:
> As Andreas has already outlined, as hot_standby_feedback is enabled
> the master has to wait for the slave and the slave cannot replay from
> the master as transactions are running on the hot standby.
Oh, thanks for the confirmation ;-) (wasn't really sure)
Andreas
--
On Tue, Jan 5, 2016 at 5:13 PM, Yoji wrote:
> I'm using version of 9.4.3.
You should update to 9.4.5 as soon as possible.
> And I have seen same behavior on version of 9.3.4.
As Andreas has already outlined, as hot_standby_feedback is enabled
the master has to wait for the slave and the slave
Andreas Kretschmer wrote:
> ok, i think it's clear now: because of running transactions on the
> standby (and hot_standby_feedback on) the master has to wait for the
> slave and can't replay all from the master.
Mhh. Maybe i'm wrong, can't reproduce that.
Andreas
--
Really, I'm not out to des
Yoji wrote:
> 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.
ok, i think it's clear now: because of running transactions on the
standby (
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 mai
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-replicatio
On Mon, Jan 4, 2016 at 9:08 PM, wrote:
> And There is System Version.
> -
> - PostgreSQL Version : 9.4
> - OS : CentOS6.4
> - Replicaion Type: async
> -
You are using a version of 9.4 older than 9
Yoji wrote:
> 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'
>
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
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 t
Hi Yoji,
Please check is there any network issues ,between master and slave server
and also share the slave server pg log output.
-Are you shipping wals to standby server using any script other than
archive_command which is mentioned master config?.
On Mon, Jan 4, 2016 at 5:58 PM, Andreas Kret
y-tsuk...@xseed.co.jp wrote:
> -
>
> Do you have any solution?
please show us your recovery.conf.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvald
Hi All,
I use streaming replication on systems.
But I have an problem.
I need your support.
The system sometimes stacks Postgres process.
So, postgresql data isn't syncing.
I checkd process that it was stacked "waiting" status on slave server.
e.g.) postgres: startup process recovering 00
16 matches
Mail list logo