migrating to 9.2 created blank dbs

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: migrating to 9.2 created blank dbs
Date: 2015-05-01 22:39:52
Message-ID: DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 "|"

Thanks

Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2015-05-02 01:20:12 Re: migrating to 9.2 created blank dbs
Previous Message Peter Geoghegan 2015-05-01 21:07:06 Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0