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

RE: moving DB

From: patrick(dot)wolf(at)Aerojet(dot)com (WOLF, PATRICK)
To: "'rocael(at)usa(dot)net'" <rocael(at)usa(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: RE: moving DB
Date: 2000-06-06 14:23:39
Message-ID: 63A19D0F08E6D211AD740008C7B1C47B02FE15DA@APD-MAIL1 (view raw or whole thread)
Lists: pgsql-novice
I think you want to use pg_dump or pg_dumpall (see the man pages).  Part of
the description for pg_dump:

pg_dump is a utility for dumping out a  Postgres  database    
into  a  script file containing query commands. The script    
files are in text format and can be  used  to  reconstruct    
the  database,  even on other machines and other architec<AD> 
tures. ......

Good luck and let me know if this works.  I'm thinking of doing an upgrade
from 6.5.3 to 7.x on the same machine.


Patrick C. Wolf
Test Manager
Socorro Plant

		-----Original Message-----
		From:	rocael(at)usa(dot)net [mailto:rocael(at)usa(dot)net]
		Sent:	Monday, June 05, 2000 8:01 PM
		To:	pgsql-novice(at)postgresql(dot)org;
		Subject:	[NOVICE] moving DB

		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...
		which are the exactly steps...

		:o) thanx


		Get free email and a permanent address at

pgsql-novice by date

Next:From: Charlie DerrDate: 2000-06-08 07:47:41
Subject: RE: any tutor/samples for installing/starting/programming onNT ?
Previous:From: Anthony E. GreeneDate: 2000-06-06 09:36:42
Subject: Re: List of tables with a query

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