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 flat)
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.

Pat


Patrick C. Wolf
Test Manager
Aerojet
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;
pgsql-sql(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

		Rocael

	
____________________________________________________________________
		Get free email and a permanent address at
http://www.netaddress.com/?N=1

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-2014 The PostgreSQL Global Development Group