Backward migration - Mailing list pgsql-general

From Francisco M. Marzoa Alonso
Subject Backward migration
Date
Msg-id 0105171218490D.04463@stormind
Whole thread Raw
Responses Re: Backward migration  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there,

I must migrate a PostgreSQL database that I've created initially with
PostgreSQL 7.0 over LiNUX to a system that has PostgreSQL 6.5.3 running on a
FreeBSD. I've no chance to update de PostgreSQL engine to a newer version so
the only way for me to do this is migrating the data.

I've used pg_dump ... and psql -e ... to do this, but I've obtained a lot of
errors and, finally, a segmentation fault; Of course, database is not
created. It seems like 6.5.3 version couldn't understand some of the commands
or the syntax generated by pg_dump on 7.0.

Help???

Thanks (a lot) in advance,


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjsDpYkACgkQdcZSl+4pW25qjwCdGkX/HjO+pN0s85wTwetRLctO
vtYAnjyJ/02zDW4RQHMOe7ihdzPVLgBY
=pWVE
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "Alex"
Date:
Subject: Timestamp Format
Next
From: "Brent R. Matzelle"
Date:
Subject: Re: Need help using PHP ODBC to connect Postgress 7.1.1