Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6E8282E004E for ; Wed, 23 Jan 2008 17:05:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 69716-02-5 for ; Wed, 23 Jan 2008 17:05:19 -0400 (AST) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 7D2B92E00CB for ; Wed, 23 Jan 2008 16:43:12 -0400 (AST) Received: (qmail 2621 invoked from network); 23 Jan 2008 15:43:17 -0500 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 23 Jan 2008 15:43:17 -0500 From: "Mark Steben" To: "'Tom Lane'" Cc: Subject: Re: no entry on pg_database for a live database Date: Wed, 23 Jan 2008 15:42:58 -0500 Message-ID: <003801c85e00$89934480$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <3710.1201022382@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 thread-index: AchdGwM+pkYoYz+vQ4GZbolq0F5MQAA5W7Eg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/229 X-Sequence-Number: 28003 Thanks Tom - that did the trick We will be upgrading to 8.2 within the next couple weeks. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, January 22, 2008 12:20 PM To: Mark Steben Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] no entry on pg_database for a live database "Mark Steben" writes: > I have a live postgres database with 4 application tables. I can access it > through PSQL. > But there is no record of this database on the PG_DATABASE catalog table. Try vacuuming pg_database. If that works, it means your routine vacuuming procedures need some re-thinking, because they are missing (at least) pg_database. > I'm running version 7.4.5. You're doing yourself no favors by failing to update. The current release in that branch is 7.4.19. regards, tom lane