From: Andy Shellam <andy.shellam@mailnetwork.co.uk>
To: 'Robin Iddon' <robin@edesix.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PITR Based replication ...
Date: Wed, 5 Apr 2006 09:45:47 +0100
Message-ID: <20060405084549.8B84311F68D2@postgresql.org> (raw)
In-Reply-To: <44337B44.5050202@edesix.com>
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@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] 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 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!
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy.shellam@mailnetwork.co.uk, robin@edesix.com
Subject: Re: PITR Based replication ...
In-Reply-To: <20060405084549.8B84311F68D2@postgresql.org>
References: <44337B44.5050202@edesix.com> <20060405084549.8B84311F68D2@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox