Re: migrating to 9.2 created blank dbs

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 “|”
>
>
>
> Thanks
>
>
>
> Marc
>
>
>
>
>

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.

--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com