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 [email protected] _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
