questions about migrating form postgres 7 to 8

On Thu, 2006-12-28 at 10:03 +0100, Piotr Szałamacha wrote:

Hello

I have question - is it som kind of guide for migrating from Postgres 7
to 8 database?

I tried to simply dump 7 and inject it to 8 but operation failed.

Use the version 8 pg_dump to connect to version 7 postgresql.

Regards

PS

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

=?ISO-8859-2?Q?Piotr_Sza=B3amacha?= <piotr@horyzont.net> writes:

I have question - is it som kind of guide for migrating from Postgres 7
to 8 database?

I tried to simply dump 7 and inject it to 8 but operation failed.

Failed how? And which 7.x and 8.x versions are you talking about?
You need to be a *lot* more specific than that if you want useful
help.

However, the one bit of useful advice I could give you is to read the
release notes for all PG versions between the two you are dealing with.
In theory all the incompatibilities should be mentioned there somewhere.
This URL is always up to date:
http://developer.postgresql.org/pgdocs/postgres/release.html

regards, tom lane