| Lists: | pgsql-testers |
|---|
| From: | Lou Picciano <loupicciano(at)comcast(dot)net> |
|---|---|
| To: | pgsql-testers <pgsql-testers(at)postgresql(dot)org> |
| Subject: | local_preload_libraries converts path to lowercase? |
| Date: | 2010-06-18 18:56:31 |
| Message-ID: | 1892486956.1137701276887391864.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-testers |
[TEST REPORT]
[Release]: 9.0beta2
[Test Type]: Application - configuration.
[Test]: Attempt to make use of the
local_preload_libraries option within postgresql.conf
[Platform]: SUN SPARC 4u Enterprise 450 Quad.
[Parameters]: attempt to use local_preload_libraries = /usr/local/lib/MyFavoriteLib.so. PG converts entire path to lowercase: /usr/local/lib/myfavoritelib.so.
[Failure]: Yes
[Results]: The Postgres binary converts the library name - in fact the entire pathname to the library - to lowercase. Attempt to connect to server using psql results in psql: FATAL: access to library " /usr/local/lib/myfavoritelib.so " is not allowed - even though permissions are 'permissive'.
[Comments]: (Whether our attempt to reference our preloaded library in this place is correct or not,) that the binary changes the directive to lower case seems odd.
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Lou Picciano <loupicciano(at)comcast(dot)net> |
| Cc: | pgsql-testers(at)postgresql(dot)org |
| Subject: | Re: local_preload_libraries converts path to lowercase? |
| Date: | 2010-06-18 20:33:11 |
| Message-ID: | 4C1BD807.2060004@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-testers |
> *[Results]:* The Postgres binary converts the library name - in fact
> the entire pathname to the library - to lowercase. Attempt to connect
> to server using psql results in psql: FATAL: access to library
> "*/usr/local/lib/myfavoritelib.so*" is not allowed - even though
> permissions are 'permissive'.
Any idea if this is an issue on 8.4 as well?
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com