Re: Clone a database to other machine

Hi,

Yes, I'm able to pg_dump the database to other server. And database is
working fine there.

But, actually I want to keep both the Databse in Sync. I want clone db
to get the data from Master in certain intervals.

DB dump size is 3 GB.

Thanks and regards,

-----Original Message-----
From: Francisco Reyes [mailto:lists(at)stringsutils(dot)com]
Sent: Monday, July 28, 2008 10:42 PM
To: Garg, Manjit
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Clone a database to other machine

On 12:44 pm 07/28/08 "Garg, Manjit" <mgarg(at)corbus(dot)com> wrote:
> I'm stuck to an issue while cloning the pgsql database, can you
> please help, or give any docs to help out.

What is the issue?

> Query - Trying to have same database on two seprate linux servers.

Have you been able to pg_dump from the source DB and then read it in the
target?

Are you trying to do replication or you just want point in times?
How large is the database?