you can use slony-i http://slony.info/
--- On Mon, 7/28/08, Garg, Manjit <[EMAIL PROTECTED]> wrote: > From: Garg, Manjit <[EMAIL PROTECTED]> > Subject: [GENERAL] Clone a database to other machine > To: pgsql-general@postgresql.org > Date: Monday, July 28, 2008, 4:44 PM > Hi All, > > I'm stuck to an issue while cloning the pgsql database, > can you please > help, or give any docs to help out. > > Query - Trying to have same database on two seprate linux > servers. One > will be used to upport Applications and other will be used > for Report > generation only. > > Want to keep both the database in Sync, hourly or nightly. > > Kindly help to achive the same. > > > > Thanks and regards, > > Manjit Garg > Corbus Global Support Team > INDIA > ------------------------------------------------------ > Email: [EMAIL PROTECTED] > Phone: +91-120-304-4000, Ext 252 > Fax : +91-120-256-7040 > > Mob : 9810679256 > ------------------------------------------------------ > > > > > > CONFIDENTIALITY NOTICE: > This message, including any attachments hereto, > (collectively the Email Message) is intended solely for the > personal and confidential use of the designated recipient(s) > and may contain privileged, proprietary, or otherwise > private information which may be subject to attorney-client > privilege or may constitute inside information protected by > law. If the reader of this message is not the intended > recipient, you are hereby notified of the following: (i) > Any disclosure, printing, copying, or distribution of this > Email Message by you or (ii) the taking of any action by > you based on the contents of this Email Message or (iii) > any other use of this Email Message by you, are strictly > prohibited. If you have received this message in error, > please notify the sender immediately and remove all traces > of the electronic mail message and its attachments from > your system. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general