X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9E4809F944D for ; Sat, 6 May 2006 10:39:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 80708-04 for ; Sat, 6 May 2006 10:39:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60413.mail.yahoo.com (web60413.mail.yahoo.com [209.73.178.156]) by postgresql.org (Postfix) with SMTP id 68DD29F9431 for ; Sat, 6 May 2006 10:39:33 -0300 (ADT) Received: (qmail 42432 invoked by uid 60001); 6 May 2006 13:39:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=A+8KXesBzr/AbaZEtUON5L1kvn6gIupbdG7mauouvRp0FpxRkNMxzjlGg7ifHAtGG7iM2I5ib+IZDGEqkJm7+AQl5mgDYlOsR+lKPiT3UGOPlc0e6V+gsTCFkB7xtlXWUoJm+20wX4NGuJpTHsYpHpH34i1kR8Z3QSdPMjE47yM= ; Message-ID: <20060506133931.42430.qmail@web60413.mail.yahoo.com> Received: from [128.249.216.215] by web60413.mail.yahoo.com via HTTP; Sat, 06 May 2006 06:39:31 PDT Date: Sat, 6 May 2006 06:39:31 -0700 (PDT) From: Mingzuo Shen Subject: databases missing To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/93 X-Sequence-Number: 21625 Hello, I have read some posts in the pg-admin list. Before I go at it, I thought I'd ask again. Thanks in advance for any pointers. I am trying to see if there are any useful data in an older PostgreSQL installation, for a client. This client, a businessman, not a computer person, has had a few DBAs in the past, and lets assume that all of the DBAs are "gone", unable to help or answer questions. select version(); PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) ls -lL /var/lib/pgsql/data/base total 36 drwx------ 2 postgres postgres 4096 Feb 13 2004 1 drwx------ 3 postgres postgres 4096 Dec 13 2004 1061329089 drwx------ 2 postgres postgres 4096 Feb 13 2004 127833810 drwx------ 2 postgres postgres 4096 Feb 13 2004 16555 drwx------ 3 postgres postgres 8192 May 6 00:20 16556 drwx------ 2 postgres postgres 4096 Aug 30 2005 873826677 drwx------ 3 postgres postgres 8192 Jan 2 13:24 945587355 as we can see, there are seven folders under .../data/base. Some folders are symlinks from other file systems, but rest assurred that the actual files are all there. So am I correct in assuming that I should see seven databases? psql -l List of databases Name | Owner | Encoding ---------+----------+----------- veritas | postgres | SQL_ASCII in other words, there is only one visible database. In particular, there are no "template0", "template1", nor "postgres". SELECT datname, age(datfrozenxid) FROM pg_database; datname | age ---------+----------- veritas | -11826501 So the course of action would be, according to what I read in the post, especially those of tom lane in response to those of Michael Beckstette, please correct me: cold backup (stop postgres, and make a copy of the OS files); /etc/rc.d/init.d/postgres start psql -d veritas veritas=# vacuum Mike