Skip site navigation (1) Skip section navigation (2)

Re: How export from 8.2.4 down to 8.1.8

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How export from 8.2.4 down to 8.1.8
Date: 2007-05-20 18:51:54
Message-ID: 3820.1179687114@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas <maps(dot)on(at)gmx(dot)net> writes:
> I'll have to export from 8.2.4 down to 8.1.8 because our provider runs 
> Debian Sarge and can't offer a newer PG.
> I tried to pg_dump a plain-text backup an run it through 8.1.8's psql. 
> That failed because of syntax errors.

In general the only answer to this type of situation is hand editing of
the dump file to deal with any syntax additions.  For this particular
combination of versions, however, some experimentation suggests that you
can get away with using 8.1's pg_dump to extract data from the 8.2
server (you'll have to give it the -i option).  You might have a bit of
difficulty with custom aggregates, but in a quick test I didn't see
anyplace else where 8.1 pg_dump failed to cope with the 8.2 system
catalogs.

But having said that ... I'm pretty sure your provider could run 8.2
if he wanted to.  Doesn't Debian offer backports?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: AndreasDate: 2007-05-20 19:49:08
Subject: Re: How export from 8.2.4 down to 8.1.8
Previous:From: Raimon FernandezDate: 2007-05-20 18:43:13
Subject: Re: return modified data from a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group