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?