Mailinglist Archive: opensuse (3261 mails)

[Tom Poe <tompoe@xxxxxxxxxx>]

Hi:  I'm in the starting stages of install for postgresql.  Seems that 
SuSE uses the directory, /var/lib/pgsql/data/pg_options to make things 
easier.  Which is good.

However, this small pea-brain is now totally confused.  The postgreSQL 
7.1 Documentation is at: 
http://www.ca/postgresql.org/users-lounge/docs/7.1/postgres/installation.html

"1.1 Short Version
./configure
gmake
gmake install
adduser postgres 
su -postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data 
- - - "

Now, seems like SuSE has streamlined everything up to the initdb part, 
'cause when I run:
tompoe@altered:~ > postmaster -D /var/lib/pgsql/data
/usr/bin/postmaster does not find the database system.  Expected to find 
it in the PGDATA directory "/var/lib/pgsql/data", but unable to open file 
with pathname "/var/lib/pgsql/data/base/template1/pg_class".
 
No data directory -- can't proceed.
tompoe@altered:~ > postgres
Can't open pid file: /var/lib/pgsql/data/postmaster.pid
Please check the permission and try again.

At this point, I decided to halt and move to the experts to check what is 
going on.  Anyone got a clear little list of commands to use as a check 
for install like the "Short Version" above they could post for me?  
Thanks, Tom