Thread: Missing Data Directory

Hello,

When I try to start PostgreSQL, this happens:


[root@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@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

Jon Williams wrote:
> Hello,
>
> When I try to start PostgreSQL, this happens:
>
>
> [root@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@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