Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
Дата
Msg-id 22705.1268683093@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump / pg_restore with Large Objects from 32-bit to 64-bit  ("Matt Janssen" <matt@luggagepros.com>)
Список pgsql-admin
"Matt Janssen" <matt@luggagepros.com> writes:
> When migrating our Postgres databases from 32 to 64-bit systems, including
> large binary objects, how well will this work?

> 32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb
> 64-bit server) pg_restore -d mydb backup.pg

Should be fine; but remember that only gets you the contents of the one
database.  You may also want pg_dumpall --globals-only to transfer
role properties and such.

> I'm hoping that PG's compressed custom archive format is not architecture
> dependant. Thanks!

It is not.

            regards, tom lane

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

Предыдущее
От: Scott Whitney
Дата:
Сообщение: Autovac vs manual with analyze
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available?