From: | "Mark Kramer" <root(at)asarian-host(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4787: Hardlink (ln) causes startup failure with bizarre "timezone_abbreviations" error |
Date: | 2009-05-01 03:04:46 |
Message-ID: | 200905010304.n4134kOT000116@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4787
Logged by: Mark Kramer
Email address: root(at)asarian-host(dot)net
PostgreSQL version: 8.3.7
Operating system: FreeBSD 7.1
Description: Hardlink (ln) causes startup failure with bizarre
"timezone_abbreviations" error
Details:
I have my PostgreSQL installed in /usr/local/PostgreSQL/ (cleaner for
updates, instead of just /usr/local) As a result, I made hard-links like
this,
cd /usr/local/bin/
ln /usr/local/PostgreSQL/bin/pg_ctl pg_ctl
Etc. Seems PostgreSQL can't handle the fact. I try and start the server,
with:
/usr/bin/su -l pgsql -c "exec /usr/local/bin/pg_ctl start -D
/var/db/PostgreSQL -w -s -m fast"
I get this error, though:
May 1 04:40:26 asarian-host postgres[9742]: [6-1] FATAL: invalid value for
parameter "timezone_abbreviations": "Default"
Which is a silly error, because it's rather untrue, and it's rather strange,
honestly, for PostgreSQL to want to be started from a hardcoded location.
Starting up the usual way, with:
/usr/bin/su -l pgsql -c "exec /usr/local/PostgreSQL/bin/pg_ctl start -D
/var/db/PostgreSQL -w -s -m fast"
Works just fine. So, at the very least, change the error message to
something that actually makes sense, like: "FATAL: Binary started from
location other than the one used at compile-time;" or something to that
affect. But better still, there's no need for PostgreSQL to have this hard
location requirement: its lib paths has been set (at boot) with ldconfig, so
it should find whatever libs it need, regardless from where the binary
resides that I use to start the server.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2009-05-01 09:40:21 | Re: BUG #4785: Installation fails |
Previous Message | Pablo M. Ronchi | 2009-05-01 01:07:12 | BUG #4786: Solution for: PostgreSQL server did not start (NET HELPMSG 3534) |