From: Tom Lane <tgl@sss.pgh.pa.us>
To: Keith <keith@keithf4.com>
cc: Marc Fromm <Marc.Fromm@wwu.edu>,
 Raghavendra <raghavendra.rao@enterprisedb.com>,
 Keith Fiske <keith@omniti.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: migrating to 9.2 created blank dbs
In-reply-to: 
 <CAHw75vvmsYV+DD_y4fTF7+0X8fT59_=1dFt3-gO1TNxZPu7sAA@mail.gmail.com>
References: 
 <DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com>
 <CAG1_KcCzq71a5F-ukHvQB4q-y34R1C=tsVYKQcZJgJr5orgzEA@mail.gmail.com>
 <CA+h6AhjFKxWzr+su4w=fchtgOtZHeOc4s0dg7KVfcp7kVtfEkA@mail.gmail.com>
 <SN1PR0201MB1566B1E4175D6905894C10CB9DD20@SN1PR0201MB1566.namprd02.prod.outlook.com>
 <CAHw75vvmsYV+DD_y4fTF7+0X8fT59_=1dFt3-gO1TNxZPu7sAA@mail.gmail.com>
Comments: In-reply-to Keith <keith@keithf4.com>
 message dated "Mon, 04 May 2015 11:18:17 -0400"
Date: Mon, 04 May 2015 12:07:29 -0400
Message-ID: <32752.1430755649@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

> 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin