Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YoJbL-0003Mx-3Y for pgsql-admin@arkaria.postgresql.org; Fri, 01 May 2015 22:40:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YoJbJ-0008H6-Iq for pgsql-admin@arkaria.postgresql.org; Fri, 01 May 2015 22:40:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YoJbI-0008Gx-Cv for pgsql-admin@postgresql.org; Fri, 01 May 2015 22:40:04 +0000 Received: from mail-by2on0063.outbound.protection.outlook.com ([207.46.100.63] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1YoJbC-0003ZT-VN for pgsql-admin@postgresql.org; Fri, 01 May 2015 22:40:02 +0000 Received: from DM2PR0201MB1070.namprd02.prod.outlook.com (25.160.221.14) by DM2PR0201MB1069.namprd02.prod.outlook.com (25.160.221.139) with Microsoft SMTP Server (TLS) id 15.1.154.19; Fri, 1 May 2015 22:39:53 +0000 Received: from DM2PR0201MB1070.namprd02.prod.outlook.com ([25.160.221.14]) by DM2PR0201MB1070.namprd02.prod.outlook.com ([25.160.221.14]) with mapi id 15.01.0154.018; Fri, 1 May 2015 22:39:53 +0000 From: Marc Fromm To: "pgsql-admin@postgresql.org" Subject: migrating to 9.2 created blank dbs Thread-Topic: migrating to 9.2 created blank dbs Thread-Index: AdCEX5JjKorrYxTTQg60YUeRdnIHew== Date: Fri, 1 May 2015 22:39:52 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none; x-originating-ip: [140.160.216.202] x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0201MB1069; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(5005006)(3002001); SRVR:DM2PR0201MB1069; BCL:0; PCL:0; RULEID:; SRVR:DM2PR0201MB1069; x-forefront-prvs: 0563F2E8B7 x-forefront-antispam-report: SFV:NSPM; SFS:(10009020)(6009001)(88552001)(90282001)(75432002)(89122001)(92566002)(62966003)(77156002)(2900100001)(76576001)(33656002)(66066001)(16236675004)(2501003)(229853001)(19300405004)(54356999)(450100001)(2351001)(86362001)(99286002)(19625215002)(19580395003)(102836002)(15975445007)(107886002)(74316001)(50986999)(46102003)(87936001)(122556002)(110136002)(2656002)(5001960100002); DIR:OUT; SFP:1101; SCL:1; SRVR:DM2PR0201MB1069; H:DM2PR0201MB1070.namprd02.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; Content-Type: multipart/alternative; boundary="_000_DM2PR0201MB10705274CE0678AC115347AF9DD50DM2PR0201MB1070_" MIME-Version: 1.0 X-OriginatorOrg: wwu.edu X-MS-Exchange-CrossTenant-originalarrivaltime: 01 May 2015 22:39:52.9069 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: dc46140c-e26f-43ef-b0ae-00f257f478ff X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR0201MB1069 X-Pg-Spam-Score: -2.1 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_DM2PR0201MB10705274CE0678AC115347AF9DD50DM2PR0201MB1070_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I setup a server running postgresql-server-9.2.10-2.el7_1.x86_64. After res= toring my databases form a system running postgresql-server-8.1.23-10.el5_1= 0 (created with pg_dumpall), several blank databases/entries were created. When I list the database from the command line it shows several entries lik= e: | | | | | =3DT/po= stgres After importing the databases is there a cleanup command of some sort? These blank databases/entries do not show in PhpPgAdmin, yet my backup scri= pt tries to backup a database called "|" Thanks Marc --_000_DM2PR0201MB10705274CE0678AC115347AF9DD50DM2PR0201MB1070_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 sh= ows several entries like:

        &nbs= p;            &= nbsp;   |          |=            |  &= nbsp;      |       |= =3DT/postgres

 

After importing the databases is there a cleanup com= mand of some sort?

These blank databases/entries do not show in PhpPgAd= min, yet my backup script tries to backup a database called “|”=

 

Thanks

 

Marc

 

 

--_000_DM2PR0201MB10705274CE0678AC115347AF9DD50DM2PR0201MB1070_--