Tony.
> I need to create a exact duplicate for a disaster recovery server, the
> disaster recovery server would not be in use until the production one
> went down for some reason.
While it's not what you asked about, copying the database files, what I do
is pg_dump nightly with a cronjob, th
Wouldn't DRBD be a better solution ? Or are you looking for a delay between
updates, so your other server is out by an hour's worth of stuff ? I guess this
is applicable if you use some Linux distro though. HTH.
Cheers,
Aly.
Steve Crawford wrote:
On Thursday 03 November 2005 07:28, Tony Cadu
You're better off doing a live backup with the PITR mechanism. That way its
not a trick (assuming you're running 8.0+). If you are archiving logs, do
select pg_start_backup();
(do rsync,tar,cp -r,whatever)
select pg_stop_backup();
Do an archive recovery with any saved logs, add 2 eggs, stir, and
On Thursday 03 November 2005 07:28, Tony Caduto wrote:
> Hi,
> Does anyone know if it would be safe to use rsync to mirror a
> Postgresql setup to a backup server?
>
> I need to create a exact duplicate for a disaster recovery server,
> the disaster recovery server would not be in use until the
> p
Tony Caduto wrote:
> Hi,
> Does anyone know if it would be safe to use rsync to mirror a Postgresql
> setup to a backup server?
>
> I need to create a exact duplicate for a disaster recovery server, the
> disaster recovery server would not be in use until the production one
> went down for
> so
