Installing with yum, Fedora core 5. Get error: "could not open file "global/pg_database": No such file or directory." The file exists however, in /var/lib/pgsql/data/global and contains 3 lines:
“postgres” 10793 1663 499 499
“template” 1 1663 499 499
“template0” 10792 1663 499 499
From the user-comments in manual, chapter 17.1: “If you get an error like psql: FATAL: could not open file "global/pg_database": No such file or directory make sure that in your init.d postgresql file (if you have one) or in the env variables for the shell that runs your server process that PGDATA is set properly. Then try to restart the server. If the server will not restart, check for an already running server process (sudo ps -af | grep postgres). Sometimes they can hang around, secretly, and screw things up.” [
http://www.postgresql.org/docs/8.1/i...e-config.html]
Reluctant to start editing the init.d file. If I su to root:
# sudo ps -af | grep postgres
root 348 332 0 09:20 pts/2 00:00:00 grep postgres
Does this mean there is indeed a server process already running? If so, how to get rid of it?
Ideas appreciated, thanks.