From: | "Sokel, John" <jsokel(at)mdsi-usa(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | RE: Copy |
Date: | 2000-09-11 14:06:24 |
Message-ID: | CAD59D8EA8B7124894637FC44951789F49703E@scratchy.int.mdsi-usa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)yahoo(dot)co(dot)uk]
Sent: Monday, September 11, 2000 8:55 AM
To: pgsql-novice(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Browning | 2000-09-11 14:15:59 | cat infile | translate all occurences of "NOT NULL" to "" |
Previous Message | Sokel, John | 2000-09-11 14:03:50 | RE: Removing all NOT NULL constraints from multiple tabl es easily |