Re: streamlined standby procedure - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: streamlined standby procedure
Date
Msg-id 1139476300.1258.278.camel@localhost.localdomain
Whole thread Raw
In response to Re: streamlined standby procedure  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: streamlined standby procedure
List pgsql-hackers
On Wed, 2006-02-08 at 11:10 +0100, Csaba Nagy wrote:
> Another issue is that unless you got the archive_command right in the
> master server from the beginning, you will have to restart the server
> once you decide to build your standby... the archive_command is a
> start-up time parameter

Much of your difficulty seems to come from your thinking that this
parameter requires a restart. It doesn't - check it out.

The script need not be complex, you only need to put a wait loop in the
restore script so that it waits for the next log file.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] Audio interview
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)