Postgres Pro
Downloads
Home   >   mailing lists

Re: Clone a database to other machine - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Clone a database to other machine
Date
Msg-id 20030729165118.GI9011@libertyrms.info
Whole thread Raw
In response to Clone a database to other machine  ("Terence Chang" <TChang@nqueue.com>)
List pgsql-general
Tree view 
On Mon, Jul 28, 2003 at 01:38:34PM -0700, Terence Chang wrote:
> customized database and initial data load into server 1. Can I just
> copy all of the database files physically from server 1 to server 2
> and server 3? I assume this is one of the method to restore a
> database.

Not unless all the databases are shut down.  You could use pg_dump.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: concurrent writes
Next
From: Andrew Sullivan
Date:
Subject: Re: pg_dump