# [EMAIL PROTECTED] / 2006-08-19 20:18:53 -0700: > 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. > > As newbie, reluctant to start editing the init.d file. > Ideas appreciated. > > ***************** > bash-3.1$ su -c 'pg_ctl start -D /usr/local/pgsql/data -l serverlog' postgres > Password: > postmaster starting > bash-3.1$ psql template1 > psql: FATAL: could not open file > "global/pg_database": No such file or directory
what does this output? su -c 'ls -l /usr/local/pgsql/data/global' postgres -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq