Postgres Pro
Downloads
Home   >   mailing lists

Re: migrating to 9.2 created blank dbs - Mailing list pgsql-admin

From Tom Lane
Subject Re: migrating to 9.2 created blank dbs
Date
Msg-id 32752.1430755649@sss.pgh.pa.us
Whole thread Raw
In response to Re: migrating to 9.2 created blank dbs  (Keith <keith@keithf4.com>)
Responses Re: migrating to 9.2 created blank dbs  (Marc Fromm <Marc.Fromm@wwu.edu>)
List pgsql-admin
Tree view 
> 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 by date:

Previous
From: Keith
Date:
Subject: Re: migrating to 9.2 created blank dbs
Next
From: Mel Llaguno
Date:
Subject: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times