Re: Duplicating a database

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Karim Nassar <Karim(dot)Nassar(at)NAU(dot)EDU>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicating a database
Date: 2004-10-23 22:40:22
Message-ID: 20041023224022.GA11107@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 21, 2004 at 01:39:26 -0700,
Karim Nassar <Karim(dot)Nassar(at)NAU(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Robinson 2004-10-23 22:51:41 COPY data and referential triggers ...
Previous Message Jonathan Weiss 2004-10-23 22:23:44 Problem with 7.4.1 and complicated queries