Thread: 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

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