Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BE0C52E3632 for ; Tue, 22 Jan 2008 13:21:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 33843-01-6 for ; Tue, 22 Jan 2008 13:21:16 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 624662E359B for ; Tue, 22 Jan 2008 13:19:45 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m0MHJgOB003711; Tue, 22 Jan 2008 12:19:42 -0500 (EST) To: "Mark Steben" cc: pgsql-admin@postgresql.org Subject: Re: no entry on pg_database for a live database In-reply-to: <000101c85d10$8bab2c10$14010a0a@dei26g028575> References: <000101c85d10$8bab2c10$14010a0a@dei26g028575> Comments: In-reply-to "Mark Steben" message dated "Tue, 22 Jan 2008 11:05:02 -0500" Date: Tue, 22 Jan 2008 12:19:42 -0500 Message-ID: <3710.1201022382@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/223 X-Sequence-Number: 27997 "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