From: | Ilya Ashchepkov <koctep(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hot standby problems: consistent state not reached, no connection to master server. |
Date: | 2015-04-14 18:39:54 |
Message-ID: | 20150415003954.493cd3ad@aii.langed.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 14 Apr 2015 07:08:50 -0700
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 04/13/2015 01:05 PM, Guillaume Lelarge wrote:
> > Le 12 avr. 2015 16:50, "Ilya Ashchepkov" <koctep(at)gmail(dot)com
> > <mailto:koctep(at)gmail(dot)com>> a écrit :
> > >
>
> > > restore_command = '/usr/lib/postgresql/9.3/bin/pg_standby -t
> > /tmp/pgsql.trigger.5432 /media/psqlbak/101/wals/main/ %f %p %r'
> > >
> >
> > Don't use pg_standby if you want to use streaming. Use cp, scp,
> > rsync, or anything else but not pg_standby. Streaming starts when
> > archive recovery fails to get next archive.
> >
>
> I have not used pg_standby, so the above was helpful. I now see that
> warning in the docs:
>
> http://www.postgresql.org/docs/9.3/static/warm-standby.html
>
> 25.2.4. Setting Up a Standby Server
>
> "Note: Do not use pg_standby or similar tools with the built-in
> standby mode described here. restore_command should return
> immediately if the file does not exist; the server will retry the
> command again if necessary. See Section 25.4 for using tools like
> pg_standby."
>
> Going to section 25.4 explained a lot. Thanks for the information.
>
Oh! I'm confused. Answer was in the manual and I can't find it.
Thanks you!
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Ashchepkov | 2015-04-14 18:40:18 | Re: Hot standby problems: consistent state not reached, no connection to master server. |
Previous Message | Ilya Ashchepkov | 2015-04-14 18:35:08 | Re: Hot standby problems: consistent state not reached, no connection to master server. |