Re: Moving a database

I’m also about to do that and also asked that a while ago (thanks to everybody who replied then).

From help, I see suggested syntax of

1) pg_dump –f filename

I guess it does the same as

2) pg_dump > filename

On the destination server, from help I’m seeing syntax like

1) pg_restore –d myDB filename

(to my guess).

That is different from

2) psql dbName < filename

but the result will probably be the same.

Then there is also:

3) psql myDB

\i filename

Is there any difference b/n the 2 dump and the 3 restore ways? If yes. which of the 2 and 3 ways are preferable?

-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Eft, Aaron
Sent: Tuesday, December 24, 2002 3:03 PM
To: 'Kent Rigby'; PGSQL Novice List
Subject: Re: [NOVICE] Moving a database

-----Original Message-----
From: Kent Rigby [mailto:kent.rigby@att.net]
Sent: Tuesday, December 24, 2002 12:54 PM
To: PGSQL Novice List
Subject: [NOVICE] Moving a database

Can someone please tell me the easiest method for moving a database from one server to another?

Pleaes be explicit, I am in the Novice group for a reason.

Kent