X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EDF8C9DCB55 for ; Wed, 25 Jan 2006 23:23:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58118-03 for ; Wed, 25 Jan 2006 23:23:19 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E35619DC9FF for ; Wed, 25 Jan 2006 23:23:12 -0400 (AST) Received: from ezbipartner.com (86.mui29.chcg.cgcil02r18.dsl.att.net [12.134.29.86]) by svr4.postgresql.org (Postfix) with ESMTP id 84FB85AF062 for ; Thu, 26 Jan 2006 03:23:18 +0000 (GMT) Received: from [127.0.0.1] (db2.ezbizpartner.net [12.134.29.88]) by ezbipartner.com (Postfix) with ESMTP id B9C6023362 for ; Wed, 25 Jan 2006 21:23:15 -0600 (CST) Message-ID: <43D840D0.4080003@ezbizpartner.com> Date: Wed, 25 Jan 2006 21:24:00 -0600 From: "Frank L. Parks" User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgresql Admin Subject: Missing Databases Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/290 X-Sequence-Number: 20378 I need some help in finding my missing databases. I did as pg_dumpall of 8.x and then updated to 8.1.2 and reloaded my databases using psql -U postgres template1 < dumpfile. I can see each one in psql -U xxxxx dbname and I can do a \dt to display the tables on the server. When I try to connect any other way (webmin/pgadmin/application) it can't find any dbs. Can anyone please point me in a direction to find the problem? Thanks, Frank