Re: pg_dump and large object?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump and large object?
Дата
Msg-id 10573.966793307@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump and large object?  ("Paul Skinner" <skin@skin.dhs.org>)
Список pgsql-novice
"Paul Skinner" <skin@skin.dhs.org> writes:
> How should one go about backing up large objects from a DB as pg_dump only
> handles the internal data and structures?

There is a pg_dumplo utility in contrib/ in current sources.  I don't
think it existed in 7.0.*, but you could probably grab the current
snapshot and compile up pg_dumplo against your 7.0.* installation.
(Disclaimer: I haven't tried it personally, don't know if it works.)

> Do I just copy the files? If the worst does happen, I can restore from the
> pg_dump file and copy all the xinv and invx files  back?

That will not work...

            regards, tom lane

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

Предыдущее
От: Mike White
Дата:
Сообщение: starting postgres
Следующее
От: doug@dupreeinc.com
Дата:
Сообщение: Re: How to connect applet to different SQL server.