RE: Copy - Mailing list pgsql-novice

From Sokel, John
Subject RE: Copy
Date
Msg-id CAD59D8EA8B7124894637FC44951789F49703E@scratchy.int.mdsi-usa.com
Whole thread Raw
In response to Copy  (syed asghar <abemail1@yahoo.co.uk>)
List pgsql-novice

I am assuming you know how to set up Postgres and get it running.  If that is the case, then all you have to do is a pg_dumpall to get your data in an external file.  FTP that file to the new machine, and then reimport it with psql. 

John

-----Original Message-----
From: syed asghar [mailto:abemail1@yahoo.co.uk]
Sent: Monday, September 11, 2000 8:55 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Copy

Hi there people.

I must warn you, I really am a novice - anyway my
problem is:

I have a postgres database on one server and I need to
move it with its contents to another server.

Should I go into the database and run some command to
do this.

Does anyone have instructions about how to get it from
one server the other server with data and get it
functional?

Any help would be apreciated.

Thanks.

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

pgsql-novice by date:

Previous
From: "Sokel, John"
Date:
Subject: RE: Removing all NOT NULL constraints from multiple tabl es easily
Next
From: "Dan Browning"
Date:
Subject: cat infile | translate all occurences of "NOT NULL" to ""