pg.ddx.io pgsql-testers@postgresql.org mailing list archive
help / color / mirror / Atom feedlocal_preload_libraries converts path to lowercase?
3+ messages / 2 participants
[nested] [flat]
* local_preload_libraries converts path to lowercase?
@ 2010-06-18 18:56 Lou Picciano <loupicciano@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: Lou Picciano @ 2010-06-18 18:56 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: local_preload_libraries converts path to lowercase?
@ 2010-06-18 20:33 Josh Berkus <josh@agliodbs.com>
parent: Lou Picciano <loupicciano@comcast.net>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2010-06-18 20:33 UTC (permalink / raw)
To: Lou Picciano <loupicciano@comcast.net>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: local_preload_libraries converts path to lowercase?
@ 2010-06-23 17:45 Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2010-06-23 17:45 UTC (permalink / raw)
To: pgsql-testers
On 6/21/10 5:11 PM, Lou Picciano wrote:
> Hello Josh,
>
> I should be more clear. It's not a problem with R; we do have R
> loading, but using Joe's recommended approach of putting R_HOME in the
> Postgresql environment. Finding that a little unsettling, and feeling
> like experimenting a bit, I tried to pre-load the .so using the .conf
> file.
OK, I'm passing this along to pgsql-bugs. I don't have the ability to
test it myself at the moment, and it's not a 9.0-specific bug.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-06-23 17:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-18 18:56 local_preload_libraries converts path to lowercase? Lou Picciano <loupicciano@comcast.net>
2010-06-18 20:33 ` Josh Berkus <josh@agliodbs.com>
2010-06-23 17:45 Re: local_preload_libraries converts path to lowercase? Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox