Re: streamlined standby procedure - Mailing list pgsql-hackers

From Tom Lane
Subject Re: streamlined standby procedure
Date
Msg-id 27495.1139336398@sss.pgh.pa.us
Whole thread Raw
In response to Re: streamlined standby procedure  (Andrew Rawnsley <ronz@investoranalytics.com>)
Responses Re: streamlined standby procedure
Re: streamlined standby procedure
List pgsql-hackers
Andrew Rawnsley <ronz@investoranalytics.com> writes:
> IMHO the #1 priority in the current PITR/WAL shipping system is to make the
> standby able to tolerate being shut down and restarted, i.e. actually having
> a true standby mode and not the current method of doing it only on startup.

How is shutting down the standby a good idea?  Seems like that will
block the master too --- or at least result in WAL log files piling up
rapidly.  If the standby goes off-line, abandoning it and starting from
a fresh base backup when you are ready to restart it seems like the most
likely recovery path.  For sure I don't see this as the "#1 priority".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: sql row constructor...works!
Next
From: Rodolfo Campos
Date:
Subject: Problems compiling a trigger