[clug] postgres

[Adrian Blake]

Is there anyone who is a postgres wizard, wizardy is what I need.

My computer failed without a recent dump of the postgres databases.

I have recovered all the files in the /var/lib/pgsql  directory.

The computer is working again, same linux version, Mandrake 9.0, same 
postgres version 7.2 etc.

psql -l reports only:

         List of databases
    Name    |  Owner   | Encoding
-----------+----------+-----------
  template0 | postgres | SQL_ASCII
(1 row)

 From what I understand template0 is a database of the databases that 
exist.

Some guidance on recovery would be appreciated.

Adrian
-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph 02 62382262  mobile 0407 232 978

http://www.physics.usyd.edu.au/astrop/most/