pg_class missing

"PO" == Phil Oelkers <Phil.Oelkers@experian.com> writes:

PO> I want to use postgresql.
PO> The error message is:
PO> /usr/bin/postmaster does not find the database system

PO> The problem seems to be:
PO> file /var/lib/pgsql/base/template1/pg_class is missing.

PO> in fact I can only find up to /var/lib/pgsgl/

PO> How do I create the missing directories and file(s) ?

PO> I installed RedHat Linux from Mandrake.

PO> Thanks

Pehaps you forgot execute 'initdb' command? This command must be
executed before any other use of Postgres.

--
Anatoly K. Lasareff Email: tolik@icomm.ru

Looks like you haven't initialised the database.

From the Administrators Guide:

"16. Create the database. Do NOT do the following as root! This would be a
major security hole. Type initdb"

executing initdb should generate your base directory.

More info is available in the User and Administration guides.

HTH,

S.

I want to use postgresql.

The error message is:
/usr/bin/postmaster does not find the database system

The problem seems to be:
file /var/lib/pgsql/base/template1/pg_class is missing.

in fact I can only find up to /var/lib/pgsgl/

How do I create the missing directories and file(s) ?

I installed RedHat Linux from Mandrake.

Thanks

Phil Oelkers
Database Analyst - Team O
Experian DirectTech

************

+--------------------------+--------------------------------------+
| Stuart C. G. Rison       | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street               |
| N.B. new phone code!!    | London, W1P 8BT                      |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM                       |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk              |
+--------------------------+--------------------------------------+

Phil Oelkers wrote:

I want to use postgresql.

The error message is:
/usr/bin/postmaster does not find the database system

The problem seems to be:
file /var/lib/pgsql/base/template1/pg_class is missing.

in fact I can only find up to /var/lib/pgsgl/

How do I create the missing directories and file(s) ?

I installed RedHat Linux from Mandrake.

One thing: I would have expected pgsql/data/base/template1/pg_class
(extra "data") Does setting the environment variable "PGDATA" to
/var/lib/pgsql/data and running initdb help?

Cheers,

Patrick