From: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> |
---|---|
To: | Jim Bryan <gooddayarizona(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cannot open pg_database |
Date: | 2006-08-21 18:19:05 |
Message-ID: | 20060821181905.GA66914@dagan.sigpipe.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
# gooddayarizona(at)yahoo(dot)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
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Philip de Nier | 2006-08-21 18:44:46 | using deferred initially deferred to solve foreign key checking issues |
Previous Message | Tom Lane | 2006-08-21 17:48:22 | Re: Queries joining views |