Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Nathan Myers
On Tue, May 15, 2001 at 05:53:36PM -0400, Bruce Momjian wrote: But, if I may editorialize a little myself, this is just indicative of a 'Fortress PostgreSQL' attitude that is easy to get into. 'We've always I have to admit I like the sound of 'Fortress PostgreSQL'. :-) Ye Olde

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: This is of little value unless the default is intelligently chosen. The default should be $PGLIB, IMHO (inserted from configure's data). This default has little value as well. Users don't generally put their loadable modules in

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Perhaps it would be good to make the empty path component equivalent to $libdir, e.g., Hmm, that would work, and also avoid having to figure out how to stuff $PGLIB into postgresql.conf during initdb. Sold as far as I'm concerned ...

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: Peter Eisentraut [EMAIL PROTECTED] writes: Perhaps it would be good to make the empty path component equivalent to $libdir, e.g., Hmm, that would work, and also avoid having to figure out how to stuff $PGLIB into postgresql.conf during initdb. While

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the other way around. Which could work as well

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the other way around. Which could work as well - or just a switch to postmaster to tell it which file to use. --

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: There is a security issue here: stuff stored in datadir is not visible to random other users on the machine (since datadir is mode 700), but I would not expect sysconfdir to be mode 700. It could be (the RPMs specify a

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: The real bottom line here, though, is that you haven't shown me any positive reason to move the config files out of datadir. It conflicts with the FHS - AFAIK, the FHS is not designed to support multiple instances of

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: There is a security issue here: stuff stored in datadir is not visible to random other users on the machine (since datadir is mode 700), but I would not expect sysconfdir to be mode

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Lamar Owen [EMAIL PROTECTED] writes: Just because we've always done it one way does not that one way correct make. Sure. We're one component of a system -- and the PostgreSQL Group has done such a good job of being platform agnostic that the platform and systems issues are almost