Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgdump 7.2 on pg-7.1

pgdump 7.2 on pg-7.1

From
Martín Marqués
Date:
I need to load a DB that's on a PostgreSQL 7.2 system on a PostgreSQL-7.1
system, and I'm getting lots of errors when I try to load it.
Is there some kind of convertion tool?

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Re: pgdump 7.2 on pg-7.1

From
Jean-Michel POURE
Date:
Le Mardi 30 Avril 2002 16:36, Martín Marqués a écrit :
> I need to load a DB that's on a PostgreSQL 7.2 system on a PostgreSQL-7.1
> system, and I'm getting lots of errors when I try to load it.
> Is there some kind of convertion tool?

Downgrading to 7.1 is not recommanded as 7.2 offers many bug fixes.
Why don't you upgrade the 7.1 database to 7.2?

Cheers,
Jean-Michel POURE

Re: pgdump 7.2 on pg-7.1

From
Martín Marqués
Date:
On Mar 30 Abr 2002 11:46, Jean-Michel POURE wrote:
> Le Mardi 30 Avril 2002 16:36, Martín Marqués a écrit :
> > I need to load a DB that's on a PostgreSQL 7.2 system on a PostgreSQL-7.1
> > system, and I'm getting lots of errors when I try to load it.
> > Is there some kind of convertion tool?
>
> Downgrading to 7.1 is not recommanded as 7.2 offers many bug fixes.

It's not a downgrade. They are two independent systems.

> Why don't you upgrade the 7.1 database to 7.2?

Don't have time to deal with that right now.

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Re: pgdump 7.2 on pg-7.1

From
Jason Earl
Date:
On Tue, 2002-04-30 at 08:54, Martín Marqués wrote:
> On Mar 30 Abr 2002 11:46, Jean-Michel POURE wrote:
> > Le Mardi 30 Avril 2002 16:36, Martín Marqués a écrit :
> > > I need to load a DB that's on a PostgreSQL 7.2 system on a PostgreSQL-7.1
> > > system, and I'm getting lots of errors when I try to load it.
> > > Is there some kind of convertion tool?
> >
> > Downgrading to 7.1 is not recommanded as 7.2 offers many bug fixes.
>
> It's not a downgrade. They are two independent systems.
>
> > Why don't you upgrade the 7.1 database to 7.2?
>
> Don't have time to deal with that right now.

If you kept the SQL statements that generated your schema in the first
place you could probably replay them on your 7.1 database.  Once your
schema was installed on the 7.1 database, then you should be able to use
pg_dump to dump out only the data.  You might need to manually add
triggers and foreign key constraints, but it should be doable.

If that seems like a lot of work, you could simply upgrade to 7.2 :).