| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Keith <keith(at)keithf4(dot)com> |
| Cc: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>, Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, Keith Fiske <keith(at)omniti(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: migrating to 9.2 created blank dbs |
| Date: | 2015-05-04 16:07:29 |
| Message-ID: | 32752.1430755649@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Fri, May 1, 2015 at 6:39 PM, Marc Fromm <Marc(dot)Fromm(at)wwu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mel Llaguno | 2015-05-04 16:19:36 | Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times |
| Previous Message | Gilberto Castillo | 2015-05-04 16:05:39 | Re: migrating to 9.2 created blank dbs |