Re: PITR Based replication ...

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(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Robin Iddon
> Sent: 05 April 2006 9:10 am
> Cc: pgsql-admin(at)postgresql(dot)org
> 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!
>