Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6F9E29FB360 for ; Fri, 6 Jul 2007 13:39:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11753-06 for ; Fri, 6 Jul 2007 13:39:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D158A9FB356 for ; Fri, 6 Jul 2007 13:39:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l66GdSxY006177; Fri, 6 Jul 2007 12:39:29 -0400 (EDT) To: "James Wilford" cc: "Alvaro Herrera" , pgsql-admin@postgresql.org Subject: Re: More than one pg_database entry for database In-reply-to: References: <11565.1183647202@sss.pgh.pa.us> <18569.1183652804@sss.pgh.pa.us> <19238.1183657129@sss.pgh.pa.us> <20070705175304.GL5500@alvh.no-ip.org> <19714.1183659436@sss.pgh.pa.us> Comments: In-reply-to "James Wilford" message dated "Fri, 06 Jul 2007 10:09:53 +0100" Date: Fri, 06 Jul 2007 12:39:28 -0400 Message-ID: <6176.1183739968@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/61 X-Sequence-Number: 26042 "James Wilford" writes: > I'd like to try the dump and reload - the only problem is that I can't > use pg_dump because of the error. And I can't rename the entry in > pg_database because my update statement won't match any rows. You can't change the dead entry, but it should work to rename the live one. BTW, you have one of the most annoying quoting styles I have ever seen: it's impossible to tell your words from those of the message you are replying to, and not trimming the overhead from that message wastes still more of your readers' time. Please change your habits, or you are likely to find that people stop reading your mail. regards, tom lane