Re: Clone a database to other machine

you can use slony-i

http://slony.info/

--- On Mon, 7/28/08, Garg, Manjit <mgarg(at)corbus(dot)com> wrote:

> From: Garg, Manjit <mgarg(at)corbus(dot)com>
> Subject: [GENERAL] Clone a database to other machine
> To: pgsql-general(at)postgresql(dot)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: 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.