From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Keith Fiske <keith(at)omniti(dot)com> |
Cc: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: migrating to 9.2 created blank dbs |
Date: | 2015-05-02 07:11:03 |
Message-ID: | CA+h6AhjFKxWzr+su4w=fchtgOtZHeOc4s0dg7KVfcp7kVtfEkA@mail.gmail.com |
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.
>>
>> When I list the database from the command line it shows several entries
>> like:
>>
>> | | | | |
>> =T/postgres
>>
>>
>>
>> After importing the databases is there a cleanup command of some sort?
>>
>> These blank databases/entries do not show in PhpPgAdmin, yet my backup
>> script tries to backup a database called “|”
>>
>
Is this behaviour, after you have imported the databases and ANALYZE
cluster ?. By-chance if you have missed to performe ANALYZE on post
import, please do it.
Did you run the 9.2 version of pg_dumpall or the 8.1 version to create your
> original dump file? You should run the 9.2 version on the 8.1 database if
> possible.
>
>
+1
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2015-05-02 10:41:58 | Re: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional? |
Previous Message | Keith Fiske | 2015-05-02 01:20:12 | Re: migrating to 9.2 created blank dbs |