Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group