Re: Duplicating a database - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Duplicating a database
Date
Msg-id 20041023224022.GA11107@wolff.to
Whole thread Raw
In response to Duplicating a database  (Karim Nassar <Karim.Nassar@NAU.EDU>)
List pgsql-general
On Thu, Oct 21, 2004 at 01:39:26 -0700,
  Karim Nassar <Karim.Nassar@NAU.EDU> wrote:
> I need to have an exact copy of a postgres install on a testing
> computer. I don't want to do slony. Is it feasible/reasonable to think
> that I could just rsync to the devel boxen from the pg server? Or is
> slony "The Way to Do It"(tm)?

If you shutdown the database cluster before doing the rsync that will work.

pgsql-general by date:

Previous
From: Jonathan Weiss
Date:
Subject: Problem with 7.4.1 and complicated queries
Next
From: James Robinson
Date:
Subject: COPY data and referential triggers ...