Merlin Moncure wrote:
> On 7/6/06, Florian G. Pflug <fgp@phlo.org> wrote:
>> Hi
>>
>> I've implemented replication to a warm standby using wal
>> logshipping now. The only remaining problem is that there
>
> just how exactly does this work? are you constantly firing up the
> standby server?
Postgres on the standby server is running constantly. The restore_command
is a shell script that waits indefinitely if a wal is requested that doesn't
exist yet. A periodic cron-jobs (every minute) syncs the archived wals over
to the standby maschine, where they are eventually picked by the restore_command.
greetings, Florian Pflug