Re: cannot open pg_database

Also, what is you $PGDATA variable pointing to? Issue:

env | grep PG

see what that comes out with.

Roman Neuhauser wrote:

># gooddayarizona@yahoo.com / 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
>
>
>


--
Email:    louis.gonzales@linuxlouis.net
WebSite:  http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka