Clone a database to other machine

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: mgarg(at)corbus(dot)com
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.