pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marc Fromm <Marc.Fromm@wwu.edu>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: migrating to 9.2 created blank dbs
Date: Fri, 1 May 2015 22:39:52 +0000
Message-ID: <DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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

view thread (14+ messages)  latest in thread

Message-ID: <DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com>
Permalink:  ../DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com/
Also on:    postgresql.org/message-id/DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Marc.Fromm@wwu.edu
  Subject: Re: migrating to 9.2 created blank dbs
  In-Reply-To: <DM2PR0201MB10705274CE0678AC115347AF9DD50@DM2PR0201MB1070.namprd02.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox