Search Postgresql Archives

Re: cannot open pg_database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



# gooddayarizona@xxxxxxxxx / 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux