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@stringsutils.com]
Sent: Monday, July 28, 2008 10:42 PM
To: Garg, Manjit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Clone a database to other machine

On 12:44 pm 07/28/08 "Garg, Manjit" <mgarg@corbus.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?