Re: Backup / export DB

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Backup / export DB
Дата
Msg-id A96152A3-2B75-41B9-B1A1-FF6C307A4AA4@khera.org
обсуждение исходный текст
Ответ на Re: Backup / export DB  (Matthias.Pitzl@izb.de)
Список pgsql-general

On Sep 22, 2006, at 3:04 AM, Matthias.Pitzl@izb.de wrote:

If you're database contains foreign keys or similar, make sure to include OIDs into the database dump.

on what basis did you make up this advice?

i have no OID's anywhere and FK's work just fine.

when you set up the new server, be sure to re-create any users you had on the old, and do the dump as the postgres superuser to ensure everything gets copied.  do the restore as the superuser too to ensure all ownerships and permissions were as before as well.

Вложения

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Backup Large Tables
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Backup roles / users