Received: from hotmail.com (law-f179.hotmail.com [209.185.131.242]) by hub.org (8.9.3/8.9.3) with SMTP id EAA77008 for ; Thu, 4 Nov 1999 04:28:51 -0500 (EST) (envelope-from oomoomi@hotmail.com) Received: (qmail 36303 invoked by uid 0); 4 Nov 1999 09:28:20 -0000 Message-ID: <19991104092820.36302.qmail@hotmail.com> Received: from 195.200.226.110 by www.hotmail.com with HTTP; Thu, 04 Nov 1999 01:28:19 PST X-Originating-IP: [195.200.226.110] From: "omid omoomi" To: hamid@emarq.com, pgsql-sql@postgreSQL.org Subject: Re: [SQL] Copying databases Date: Thu, 04 Nov 1999 01:28:19 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed hi, AFAIK, since there is no database replication supported in pg,the only way I think is to dumping out your data ( owned by user ) using pg_dump or pg_dumpall . Due to some limitatins on pg_dump function, the new database would need some regulations after creation.Look at the pg help docs. regards, omid omoomi >From: "Hamid Khoshnevis" >To: >Subject: [SQL] Copying databases >Date: Wed, 3 Nov 1999 21:54:33 -0800 > >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 > > >************ > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com