Problem with migration - Mailing list pgsql-novice

From radgar@wp.pl
Subject Problem with migration
Date
Msg-id 1161338820.754459.301630@b28g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: Problem with migration
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: [SQL] [GENERAL] How to split a table?
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: [SQL] [GENERAL] How to split a table?