Postgres Pro
Downloads
Home   >   mailing lists

Thread: Backward migration

Backward migration

From
"Francisco M. Marzoa Alonso"
Date:
-----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-----

Re: Backward migration

From
"Valerio Santinelli"
Date:
I think you should post the exact errors you're getting to the mailing list,
so maybe someone can help you.

Valerio Santinelli
Digisoft Multimedia
http://www.digisoftmultimedia.it/

----- Original Message -----
From: "Francisco M. Marzoa Alonso" <fmmarzoa@e-quantica.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, May 17, 2001 12:18 PM
Subject: [GENERAL] Backward migration


> -----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-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Re: Backward migration

From
Lincoln Yeoh
Date:
At 12:18 PM 17-05-2001 +0200, Francisco M. Marzoa Alonso wrote:
>-----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???
>

It is probably a better idea to upgrade to 7.1.x at this moment. It doesn't
really take that much time, probably the same amount of time (or even less)
to get your 7.0 data working in a 6.5.3 environment.

You could also run 7.1.x concurrently with 6.5.3 if necessary.

Cheerio,
Link.