Copying databases

From: "Hamid Khoshnevis" <hamid(at)emarq(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Copying databases
Date: 1999-11-04 05:54:33
Message-ID: 000a01bf2689$11d1cb40$810a0a0a@hamid.emarq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)emarq(dot)com

Browse pgsql-sql by date

  From Date Subject
Next Message Frederic boucher 1999-11-04 07:36:56 Accessing other database...
Previous Message omid omoomi 1999-11-04 01:28:19 Re: [SQL] Copying databases