Received: from pop1-rme.xtra.co.nz (pop1-rme.xtra.co.nz [203.96.92.5]) by hub.org (8.10.1/8.10.1) with ESMTP id e567cUW64737; Tue, 6 Jun 2000 03:38:30 -0400 (EDT) Received: from berty ([210.55.151.247]) by pop1-rme.xtra.co.nz (InterMail vM.4.01.02.17 201-229-119) with SMTP id <20000606073821.RZVO4575868.pop1-rme.xtra.co.nz@berty>; Tue, 6 Jun 2000 19:38:21 +1200 From: Christopher Sawtell Organization: iOpen Technologies Ldt To: , pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] moving DB Date: Tue, 6 Jun 2000 19:33:43 +1200 X-Mailer: KMail [version 1.0.29.1] Content-Type: text/plain References: <20000606020115.18434.qmail@nwcst313.netaddress.usa.net> In-Reply-To: <20000606020115.18434.qmail@nwcst313.netaddress.usa.net> MIME-Version: 1.0 Message-Id: <00060619402701.15623@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200006/35 On Sat, 12 Jul 2036, rocael@usa.net wrote: > Hi all! > > well, can somebody tell me how to move a DB (e.g. I have a DB named NET in > PC1 under pg6.5.3 and I want to put it in PC2 under pg7.0) > should I copy just the data/base/NET/ directory and the paste it in the > data/base of the PC2... No, No, don't do that. pg7.x cannot read databases created by pg6.5.3 > which are the exactly steps... > > :o) thanx use pg_dumpall on PC1 and then read it back in on the other system. pg_dumpall -o > db.out # on PC1 move the db.out file to PC2 in whatever way is appropriate. psql -e template1 < db.out # on PC2 -- Sincerely etc., NAME Christopher Sawtell - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz WWW http://www.iopen.co.nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--