Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Rosser Schwarz
On 4/5/06, Robin Iddon <[EMAIL PROTECTED]> wrote:[-l $LOGFILE] Hope this helps,It did, thanks./rls-- :wq

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Anyone have any suggestions on novel phrases to offer in my incantations for getting this script to do everything I need? You need to add "-l $LOGFILE" where log is wherever you want to write the stderr+stdout from the postmaster to. Then it will return once starting the server. Also, is

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Rosser Schwarz
On 4/5/06, Robin Iddon <[EMAIL PROTECTED]> wrote: Andy Shellam wrote:>I have, however, recently developed an interest in rsync but I'm unsure as >to how PG on the standby server would handle a complete rsync'd data>directory. There has just recently been a fairly extensive discussion on this listab

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Marc G. Fournier
On Wed, 5 Apr 2006, Robin Iddon wrote: Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Andy Shellam wrote: Robin, On my part it's simply the fact that I currently have two servers in different geographical locations - and cost of new hardware is a huge issue. I have, however, recently developed an interest in rsync but I'm unsure as to how PG on the standby server would handle

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Andy Shellam
te rsync'd data directory. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Robin Iddon > Sent: 05 April 2006 9:10 am > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] PITR Based replication ... > >

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Robin Iddon
Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... We use linux HA and linux DRBD (~RAID1 mirror between disks across a LAN) to provide a similar replication mechanism that runs "underneath" the database rath

Re: [ADMIN] PITR Based replication ...

2006-04-04 Thread Jeff Frost
On Tue, 4 Apr 2006, Thomas F. O'Connell wrote: On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote: I'll be curious to hear stories of people using it for replication. The way I interpret replication, there's an available database (even if read-only) on both ends. With PITR/on-line backups, th

Re: [ADMIN] PITR Based replication ...

2006-04-04 Thread Thomas F. O'Connell
On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... I'll be curious to hear stories of people using it for replication. The way I interpret replication, there's an available data