X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id B8CD5D1C4E3 for ; Mon, 28 Jul 2003 15:15:00 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 98945-01 for ; Mon, 28 Jul 2003 12:14:03 -0300 (ADT) Received: from cosimo.hosting365.ie (sprocket.hosting365.ie [217.114.166.205]) by svr1.postgresql.org (Postfix) with ESMTP id D56C8D1C4CB for ; Mon, 28 Jul 2003 12:14:57 -0300 (ADT) Received: from cosimo.hosting365.ie (localhost.localdomain [127.0.0.1]) by cosimo.hosting365.ie (8.12.8/8.12.8) with ESMTP id h6SFEfbJ014772 for ; Mon, 28 Jul 2003 16:14:41 +0100 Received: (from john@localhost) by cosimo.hosting365.ie (8.12.8/8.12.8/Submit) id h6SFEeTb014770 for pgsql-admin@postgresql.org; Mon, 28 Jul 2003 16:14:40 +0100 X-Authentication-Warning: cosimo.hosting365.ie: john set sender to john@hosting365.ie using -f Subject: From: "John P. Looney" To: postgres Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Hosting 365 Message-Id: <1059405280.4988.167.camel@cosimo.hosting365.ie> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 28 Jul 2003 16:14:40 +0100 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/372 X-Sequence-Number: 9712 What's up here ? Google is deathly silent. bash-2.05a$ pg_dumpall > db.out connected to template1... dumping database "MyPgSQLTest"... dumping database "bb1"... dumping database "bbadmin"... pg_dump: [archiver (db)] connection to database "bbadmin" failed: FATAL 1: SetDatabaseEncoding(): invalid database encoding pg_dump failed on bbadmin, exiting Hmm. Curiously, the database I'm playing with; bbadmin | | SQL_ASCII Says it is SQL_ASCII...but it doesn't have an owner. Would this mean the database is corrupt ? This is on 7.2.3 - I had been running 7.1.3 and upgraded with the assistance pg_dumpall. Is this an artifact of the upgrade ? John