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

Re: [ADMIN] PITR Based replication ...

2006-04-05 Thread Andy Shellam
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 ... Marc G. Fournier wrote: I know ppl are using

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 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

[ADMIN] PITR Based replication ...

2006-04-04 Thread Marc G. Fournier
I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

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

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,