pg_dump - txt sql vs binary

Поиск
Список
Период
Сортировка
От Ciprian Hodorogea
Тема pg_dump - txt sql vs binary
Дата
Msg-id 20060122204132.9567D14DB13@mail07.powweb.com
обсуждение исходный текст
Ответы Re: pg_dump - txt sql vs binary  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin

Hi All,

 

  1. I noticed that binary dumps created with Postgres 8.0.3 can not be imported with Postgres 8.1.x, so this is not a good backup idea.

 

  2. All dumps generated with pg_dump seem to contain internal functions also, which then raise problems when trying to import. Can these be somehow excluded from the generated SQL backup?

 

  All I want is to obtain a valid SQL file that I can then import within any upcoming version of Postgres.  Does anyone have any suggestion please?

 

Best regards,

 

Ciprian Hodorogea

IntelliSoft SRL

http://www.bitsp.com/

 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What happens to transactions durring a pg_dump?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump - txt sql vs binary