Обсуждение: Backward migration

Поиск
Список
Период
Сортировка

Backward migration

От
"Francisco M. Marzoa Alonso"
Дата:
-----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

От
"Valerio Santinelli"
Дата:
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

От
Lincoln Yeoh
Дата:
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.