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

radgar@wp.pl writes:
> 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).

Oy, that's old.

> Is there any way to move the pgsql user database (pg_shadow)?

pg_dumpall should do that for you.  It will probably work better if you
run the 7.4 version of pg_dump and pg_dumpall against the 7.0 server
than if you use 7.0's dump tools --- the resulting script is much more
likely to load into 7.4 without hassles.  But given the version gap you
are trying to migrate across, you should expect to have to make some
manual adjustments ... the differences between 7.0 and 7.4 are *major*.

            regards, tom lane

The typical answer is to use pg_dumpall from the newer version to dump the information in the older version.  Then, do
therestore 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@wp.pl [mailto:radgar@wp.pl]
Sent: Fri 10/20/2006 6:07 AM
To: pgsql-novice@postgresql.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@postgresql.org so that your
       message can get through to the mailing list cleanly