RE: Copy

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

Browse pgsql-novice by date

  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