Postgres Pro
Downloads
Home   >   mailing lists

Copying databases - Mailing list pgsql-sql

From Hamid Khoshnevis
Subject Copying databases
Date
Msg-id 000a01bf2689$11d1cb40$810a0a0a@hamid.emarq
Whole thread Raw
List pgsql-sql
Tree view 
I need to have identical copies of the same database on 2 different
machines. Can I simply file copy all of the source files to the destination
machine.  Do I have to bring PG down on the destination before doing this
(assuming no one is actively hitting the destination db).

Thanks!

hamid

Hamid Khoshnevis
emarQ.com
1488-1188 W. Georgia St.
Vancouver, BC  V6E 4A2, Canada
Ph: (604) 687-7111
Fx: (604) 687-7222
http://www.emarq.com
hamid@emarq.com

pgsql-sql by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Optimizing a query through its syntax and indices
Next
From: "omid omoomi"
Date:
Subject: Re: [SQL] Copying databases