From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Streaming replication stacked. |
Date: | 2016-01-05 06:28:56 |
Message-ID: | 20160105062856.GA29256@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yoji <y-tsukada(at)xseed(dot)co(dot)jp> wrote:
> Hi, Andreas
>
> Thank you for reply.
>
> Below is the recovery.conf.
>
> ----------------------------------------------
> standby_mode = on
> primary_conninfo = 'host=172.16.xxx.xxx user=xxxxxx'
> trigger_file = '/tmp/trigger_file0'
> ----------------------------------------------
Seems okay for me, can't find any errors. (neihter here nor in the other
config you shown)
(you have only 1 slave, right?)
Do you have long running transactions on the slave? What happens if you
restart the slave?
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-01-05 06:35:27 | Re: Streaming replication stacked. |
Previous Message | Arthur Pemberton | 2016-01-05 05:39:47 | Re: Cannot upgrade from 9.3 to 9.4 using pg_upgrade |