Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc Fromm
Subject migrating to 9.2 created blank dbs
Date
Msg-id DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com
Whole thread Raw
Responses Re: migrating to 9.2 created blank dbs
List pgsql-admin
Tree view

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

 

 

pgsql-admin by date:

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