Re: Clone a database to other machine

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Clone a database to other machine
Date: 2003-07-29 16:51:18
Message-ID: 20030729165118.GI9011@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Freddy Mnjvr 2003-07-29 17:00:13 how to get postgresql page size?
Previous Message Andrew Sullivan 2003-07-29 16:47:39 Re: pg_dump