| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL shipping question |
| Date: | 2007-12-04 16:05:10 |
| Message-ID: | 47557AB6.8060703@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glen W. Mabey | 2007-12-04 16:11:04 | Re: difficulty extracting variable-sized field on triggered row |
| Previous Message | Tom Lane | 2007-12-04 15:53:37 | Re: difficulty extracting variable-sized field on triggered row |