Re: Problem with migration

The typical answer is to use pg_dumpall from the newer version to dump the information in the older version. Then, do the restore on the newer version. Try that. If it doesn't work, then you can at least post the error messages that you receive.

Sean

-----Original Message-----
From: radgar(at)wp(dot)pl [mailto:radgar(at)wp(dot)pl]
Sent: Fri 10/20/2006 6:07 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Problem with migration

Hi,

What I tried to achieve is move pgsql database from one machine to
another. Obviously the new machine has also new version of pgsql (7.4,
it's not actually "new"; the old machine has pgsql 7.0 installed).

I read a lot of different howto's and simple tips - nothing worked
(starting with the migration.html document) - everything failed. I
figured out that the problem lays with the pg_dumpall not creating the
databases (-d worked most of times - not sure, didn't record every move
I took), but it didn't create the users (pgsql users that is). So my
question is:

Is there any way to move the pgsql user database (pg_shadow)? Or has
anyone got an idea how to simply move from one version to other on two
different machines?

regards,
Rafal Mroz

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly