Re: How export from 8.2.4 down to 8.1.8

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How export from 8.2.4 down to 8.1.8
Дата
Msg-id 3820.1179687114@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How export from 8.2.4 down to 8.1.8  (Andreas <maps.on@gmx.net>)
Ответы Re: How export from 8.2.4 down to 8.1.8  (Andreas <maps.on@gmx.net>)
Список pgsql-novice
Andreas <maps.on@gmx.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Raimon Fernandez
Дата:
Сообщение: Re: return modified data from a function
Следующее
От: Andreas
Дата:
Сообщение: Re: How export from 8.2.4 down to 8.1.8