Re: Replication, HA ...?

From: Marcin Kasperski <Marcin(dot)Kasperski(at)softax(dot)com(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication, HA ...?
Date: 2008-06-16 12:21:51
Message-ID: 87ve091sf4.fsf@softax.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I have a webserver with postgresql. I would have a backup from this
> database. It should also be possible to query this backup solution.
> So I think slony would be a good choice. Am I right?

Slony will replicate the data from selected tables for you, and the
replicated database will be available for queries. So it will work for
you unless you face performance limits, or have some problem with
asynchronous updates, or find Slony setup to be too difficult.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-06-17 02:32:58 Re: I: Purge Oid
Previous Message Peter Eisentraut 2008-06-16 11:25:12 Re: What is the difference between Logical link and Foreign Key link in Postgresql