Jon Williams wrote:
> Hello,
>
> When I try to start PostgreSQL, this happens:
>
>
> [root(at)betelgeuse /root]# /etc/rc.d/init.d/postgresql start
> Starting postgresql service: /usr/bin/postmaster does not find the
> database system. Expected to find it in the PGDATA directory
> "/var/lib/pgsql", but unable to open file with pathname
> "/var/lib/pgsql/base/template1/pg_class".
>
> No data directory -- can't proceed.
> postmaster []
> [root(at)betelgeuse /root]#
>
>
> The same thing happens when PostgreSQL tries to start when the system
> boots up. I have tried everything I can think of including
> reinstalling PostgreSQL (which by the way was done through RPM).
> What do I need to do to create pg_class? Is there anything else I
> need to do to get PostgreSQL to work?
>
> (I am using Red Hat Linux 6.0 and PostgreSQL version 6.4.2.)
>
> Jon Williams
>
>
initdb -D /var/lib/pgsql
should create the database area
You will need to do this as the same user who starts the postmaster
(normally postgres).
hth,
- Stuart