Re: pg_dumpall storing multiple copies of DB's?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall storing multiple copies of DB's?
Дата
Msg-id 20116.1014789135@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall storing multiple copies of DB's?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
Ответы Re: pg_dumpall storing multiple copies of DB's?
Список pgsql-general
Bill McGonigle <mcgonigle@medicalmedia.com> writes:
> Just checked pg_shadow, and each usesysid is unique.

Drat, another perfectly good theory down the drain.

Please look in the pg_dumpall script to see the query it uses to get the
list of database names, and run that query by hand to see if you get
duplicates.  If so, can you figure out why?

> In pg_database, every datlastsysoid is the same, 18539 - is that OK?

Yes, that's expected.

            regards, tom lane

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

Предыдущее
От: Bill McGonigle
Дата:
Сообщение: Re: pg_dumpall storing multiple copies of DB's?
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: [ADMIN] configure --with-pam