Re: Backing up the currently used wal segment - Mailing list pgsql-general

From Florian G. Pflug
Subject Re: Backing up the currently used wal segment
Date
Msg-id 44AD52AC.9060007@phlo.org
Whole thread Raw
In response to Re: Backing up the currently used wal segment  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Backing up the currently used wal segment
Next
From: Michael Fuhr
Date:
Subject: Re: How to hide NOTICE messages in psql.exe ?