Re: WAL shipping question - Mailing list pgsql-general

From Richard Huxton
Subject Re: WAL shipping question
Date
Msg-id 47557AB6.8060703@archonet.com
Whole thread Raw
In response to WAL shipping question  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
SHARMILA JOTHIRAJAH wrote:
> Hi,
> Im trying to play a bit with log shipping between 2 servers primary and standby. These servers are running versions
8.3betat3.I had set up continuous archiving at the primary server. The manuals' example of archive_command is 
> archive_command = 'cp -i %p /mnt/server/archivedir/%f </dev/null'
>
> This basically archives the data in the primary server itself...right!!!
> But how can I set up continuous archiving from primary to a directory (WAL archive directory)
> on the stand-by server ?

a. Mount the remote directory via NFS/SMBFS/...
b. Use a remote copy, e.g. scp, FTP...

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: difficulty extracting variable-sized field on triggered row
Next
From: "Glen W. Mabey"
Date:
Subject: Re: difficulty extracting variable-sized field on triggered row