pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
local_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