Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL and Windows 2003 DFS Replication

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL and Windows 2003 DFS Replication
Date: 2006-07-27 15:57:39
Message-ID: 1154015858.22367.149.camel@coppola.muc.ecircle.de (view raw or flat)
Thread:
Lists: pgsql-general
> for a cold/warm standby postgresql backup, I'd suggest using pitr.

I found that PITR using WAL shipping is not protecting against all
failure scenarios... it sure will help if the primary machine's hardware
fails, but in one case it was useless for us: the primary had a linux
kernel with buggy XFS code (that's what I think it was, cause we never
found out for sure) and we did use XFS for the data partition, and at
one point it started to get corruptions at the data page level. The
corruption was promptly transferred to the standby, and therefore it was
also unusable... we had to recover from a backup, with the related
downtime. Not good for business...

> It's easy to set up and administer. for hot read only backup, bite the
> bullet and use slony.

I think slony would have helped us recovering from the above mentioned
situation earlier and easier, as it transfers logical data and not pages
directly. It has though a bigger overhead than WAL shipping in terms of
administration and performance penalty.

Cheers,
Csaba.



In response to

Responses

pgsql-general by date

Next:From: Ian JohnsonDate: 2006-07-27 16:22:33
Subject: Can't start PostgreSQL
Previous:From: A. KretschmerDate: 2006-07-27 15:51:51
Subject: Re: Update entire column with new date values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group