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

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 (view raw or flat)
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

pgsql-admin by date

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

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