Re: archive is compressed - any data will not be available

Поиск
Список
Период
Сортировка
От Iain
Тема Re: archive is compressed - any data will not be available
Дата
Msg-id 001501c4e67d$1ed4cea0$7201a8c0@mst1x5r347kymb
обсуждение исходный текст
Ответ на archive is compressed - any data will not be available  ("Iain" <iain@mst.co.jp>)
Список pgsql-admin
Hi,

Thanks for that. It seems that you were right.

We used pg_restore to create a plain text dump file on the original machine
and brought that down to the other machine which worked fine.

regards
Iain

> Apparently you are trying to load into a server compiled with different
> options --- specifically, the destination software was built without zlib
> and so has no ability to read (nor create) compressed archives.
>
> Your choices are to go back to the source DB and tell pg_dump to dump
> without compression, or to rebuild the destination DB with zlib
> available.
>
> I think, but wouldn't entirely swear to it, that zlib is only used in
> pg_dump/pg_restore, so it might be sufficient to rebuild those two
> programs and not the whole Postgresql suite.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


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

Предыдущее
От: Stefan Sobernig
Дата:
Сообщение: unsubscribe pgsql-admin
Следующее
От: Helena Lourenco
Дата:
Сообщение: unsubscribe pgsql-admin