Re: [BUGS] could not find /usr/local/timezone

2004-11-06 Thread Tom Lane
I wrote: >> dropping symlinks to the pg binaries in /usr/bin or >> /usr/local/bin or /sbin/ is something I've done for ages, on PostgreSQL >> versions 7.1 -> 7.4. Is there a problem with this now? > This is fundamentally broken by the changes to support relocatable > installs: PG now attempts to

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> This is fundamentally broken by the changes to support relocatable >> installs: PG now attempts to find the support files by relative paths >> from the place where the executable was found. > I recall that on some systems the "norma

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Bruce Momjian
Is this an open 8.0 item? --- Peter Eisentraut wrote: > Tom Lane wrote: > > This is fundamentally broken by the changes to support relocatable > > installs: PG now attempts to find the support files by relative paths > > fr

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Peter Eisentraut
Tom Lane wrote: > This is fundamentally broken by the changes to support relocatable > installs: PG now attempts to find the support files by relative paths > from the place where the executable was found. I recall that on some systems the "normal" method of installation is installing everything

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Josh Berkus
Tom, > This is fundamentally broken by the changes to support relocatable > installs: PG now attempts to find the support files by relative paths > from the place where the executable was found. OK, I can see the tradeoff.Hmmm ... this means that we need something in the Release Notes, I wou

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Josh Berkus
Tom, > What it looks like is that the postmaster was executed out of /usr/bin. > Have you got any symlinks you aren't telling us about? ÂWhere does that > mount point to, anyway? Yes, there are symlinks in /usr/bin to /usr/local/pgsql/bin. I've never had it cause issues before, though. H

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Tom Lane
"Josh Berkus" <[EMAIL PROTECTED]> writes: >> What it looks like is that the postmaster was executed out of >> /usr/bin. > dropping symlinks to the pg binaries in /usr/bin or > /usr/local/bin or /sbin/ is something I've done for ages, on PostgreSQL > versions 7.1 -> 7.4. Is there a problem with t

Re: [BUGS] could not find /usr/local/timezone

2004-11-04 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> As best I can tell, this is coming out because pgtz.c thinks that >> /usr/share/timezone is where Postgres' own timezone files are; which >> implies that get_share_directory() is returning /usr/share; which does >> not make a lot of sense. > Nope: > $ .

Re: [BUGS] could not find /usr/local/timezone

2004-11-03 Thread Josh Berkus
Tom, > As best I can tell, this is coming out because pgtz.c thinks that > /usr/share/timezone is where Postgres' own timezone files are; which > implies that get_share_directory() is returning /usr/share; which does > not make a lot of sense. I think you must have used nondefault > configuration

Re: [BUGS] could not find /usr/local/timezone

2004-11-03 Thread Tom Lane
>> Please. Also, what nondefault configuration or postgresql.conf settings >> are you using? > Sorry for delay. Attached. > And --with-perl --with-odbc As best I can tell, this is coming out because pgtz.c thinks that /usr/share/timezone is where Postgres' own timezone files are; which implies

Re: [BUGS] could not find /usr/local/timezone

2004-11-01 Thread Josh Berkus
Tom, > Please. Also, what nondefault configuration or postgresql.conf settings > are you using? Sorry for delay. Attached. And --with-perl --with-odbc -- --Josh Josh Berkus Aglio Database Solutions San Francisco gentoobug.gz Description: GNU Zip compressed data --

Re: [BUGS] could not find /usr/local/timezone

2004-10-31 Thread Josh Berkus
Tom, > Please. Also, what nondefault configuration or postgresql.conf settings > are you using? Will have to get the trace tommorrow. Config options are --with-perl and --with-odbc -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--

Re: [BUGS] could not find /usr/local/timezone

2004-10-31 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> Hmmm ... where is that coming from exactly? PG itself should not be >> referring to /usr/share/timezone --- we have our own TZ database now. > Let me know if you want a trace. Please. Also, what nondefault configuration or postgresql.conf settings are

Re: [BUGS] could not find /usr/local/timezone

2004-10-31 Thread Josh Berkus
Tom, > Hmmm ... where is that coming from exactly? PG itself should not be > referring to /usr/share/timezone --- we have our own TZ database now. > And glibc-based platforms don't keep their info there either (it's in > /usr/share/zoneinfo, at least on my Fedora machine). So there's > something

Re: [BUGS] could not find /usr/local/timezone

2004-10-29 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > LOG: could not open directory "/usr/share/timezone": No such file or > directory > What's it mean? Am I missing a package? Hmmm ... where is that coming from exactly? PG itself should not be referring to /usr/share/timezone --- we have our own TZ data

[BUGS] could not find /usr/local/timezone

2004-10-29 Thread Josh Berkus
Folks, This is a new one on me, but possibly because it's my first time working on Gentoo: Version: 8.0b4 Platform: Gentoo Linux 2.6.8 Severity: Unknown Message: LOG: could not open directory "/usr/share/timezone": No such file or directory What's it mean? Am I missing a package? -- --Jos