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 a complete rsync'd data directory. Andy > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin- > owner@xxxxxxxxxxxxxx] On Behalf Of Robin Iddon > Sent: 05 April 2006 9:10 am > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: [ADMIN] PITR Based replication ... > > 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 rather than PITR between the database servers. > > I see a lot of interest on this list for the WAL copying solution, and I > am wondering if that is because people have discounted a DRBD solution > or that it has been overlooked? > > Thanks, > Robin > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > !DSPAM:14,44337b9c35048018610585! >
