Re: Replication, HA ...? - Mailing list pgsql-admin

From Marcin Kasperski
Subject Re: Replication, HA ...?
Date
Msg-id 87ve091sf4.fsf@softax.com.pl
Whole thread Raw
In response to Replication, HA ...?  (Andreas Kraftl <andreas.kraftl@kraftl.at>)
List 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.


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: What is the difference between Logical link and Foreign Key link in Postgresql
Next
From: "Scott Marlowe"
Date:
Subject: Re: I: Purge Oid