On 19/04/2011 14:11, Dinakaran Kanagaraj wrote:
> Hi,
>
> I have a PostgreSQL 8.4.3 database running on SuSe Linux Ent server. My
> requirement is to replicate this database to another machine just for a
> backup.
>
> Database Details:
>
> On a weekly basis, the application (which uses postgres database) will
> create few no. Of new tables in the database. So, whenever I do
> replicate, I need to replicate it with these new tables also.
>
> Please let know if this can be achieved by Slony1. Also, please let know
> is there any license for getting the Slony product.


You can use SLony for this, but it won't pick up the new tables 
automatically - you'll have to add them to the replication set by hand.

If you were on PostgreSQL 9+, you could use it's built-in replication - 
as it's WAL-based, I think it will pick up new tables.

If you're just backing up the database, could you use pg_dump instead?

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod at iol.ie