On 12/20/10 5:09 PM, Rich Shepard wrote:
I built and installed -9.0.1 on my Slackware-13.1 server and it ran
for a
while. Now, without warning, one of my applications dependent upon
postgres
won't run. While trying to restart postgres I learned the .pid file
did not
exist so I removed /tmp/.s.PGSQL* and tried to restart postgres.
Here's what I see:
postgres@salmo:$ postgres -D /usr/local/pgsql/data &
[1] 16044
postgres@salmo:/var/log/httpd$ LOG: could not open directory
"/share/timezone": No such file or directory
LOG: could not open directory "/share/timezone": No such file or
directory
LOG: could not open directory "/share/timezone": No such file or
directory
LOG: could not open directory "/share/timezone": No such file or
directory
LOG: could not open directory "/share/timezone": No such file or
directory
WARNING: could not open directory "/share/timezonesets": No such file or
directory
HINT: This may indicate an incomplete PostgreSQL installation, or
that the
file "/bin/postgres" has been moved away from its proper location.
FATAL: invalid value for parameter "timezone_abbreviations": "Default"
The files and directories are in /usr/local/pgsql/share:
if you built and installed postgres in /usr/local/pgsql, then all those
errors should have referred to /usr/local/pgsql/share/timezone
is there a different postgres binary in /bin/postgres ?
execute...
postgres@salmo:$ /usr/local/pgsql/bin/pg_config
and reply to the list with the output...
also,
postgres@salmo:$ which postgres
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
