Re: migrating to 9.2 created blank dbs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: migrating to 9.2 created blank dbs
Дата
Msg-id 32752.1430755649@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: migrating to 9.2 created blank dbs  (Keith <keith@keithf4.com>)
Ответы Re: migrating to 9.2 created blank dbs  (Marc Fromm <Marc.Fromm@wwu.edu>)
Список pgsql-admin
> On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
>> I setup a server running postgresql-server-9.2.10-2.el7_1.x86_64. After
>> restoring my databases form a system running
>> postgresql-server-8.1.23-10.el5_10 (created with pg_dumpall), several blank
>> databases/entries were created.

FWIW, this seems to match a symptom we've heard of occasionally in which
the source server's catalogs are corrupted.  If the 8.1 server is still
online it would be interesting to connect to it manually and see what
you get from "select * from pg_database".

            regards, tom lane


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

Предыдущее
От: Keith
Дата:
Сообщение: Re: migrating to 9.2 created blank dbs
Следующее
От: Mel Llaguno
Дата:
Сообщение: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times