From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | ghazel(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6756: primary_conninfo is ignored if restore_command is set.. |
Date: | 2012-07-25 16:00:05 |
Message-ID: | CAHGQGwEcDAgDpkfsDGrxt=SqABJzt7f25GkrLpWxnnef3mJtYw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Jul 25, 2012 at 10:42 AM, <ghazel(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6756
> Logged by: Greg Hazel
> Email address: ghazel(at)gmail(dot)com
> PostgreSQL version: 9.1.4
> Operating system: Amazon Linux
> Description:
>
> Trying to get a slave to stream updates from a master, I had both:
>
> restore_command = 'pg_standby /data/pgsql9/archive %f %p %r 2>>standby.log'
>
>
> and:
>
> primary_conninfo = 'host=10.x.y.z port=5432 user=postgres'
>
> This configuration never streamed from the master, even after restarts,
> waiting hours, etc. After all that, I removed restore_command and restarted,
> and the slave started streaming immediately.
>
> This seems to contradict many guides and the documentation I've found.
No. You need to use cp or something instead of pg_standby if you'd like to
use streaming replication. pg_standby is the tool for file-based log shipping
replication.
Regards,
--
Fujii Masao
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-07-25 16:17:00 | Re: BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1 |
Previous Message | bert | 2012-07-25 12:53:01 | BUG #6761: unexpected behaviour of 'now'::timestamp |