Thread: questions about migrating form postgres 7 to 8
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. Regards PS -- ----------------------------------------------------------------- Piotr Szałamacha Horyzont Technologie Internetowe E-mail: piotr@horyzont.net Web: http://www.horyzont.net tel. +48 61 858 22 55, +48 61 622 95 00, fax. +48 61 858 22 56 ul. Półwiejska 24 61-888 Poznań Polska
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