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

#1

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?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#2

Josh Berkus <josh (AT) agliodbs (DOT) com> writes:

Quote:

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 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 awfully odd here.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

#3

Tom,

Quote:

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 awfully odd here.

That's postmaster's feedback on startup. Here's a clue: when I tried to
enable automated log rotation (using the default filenaming scheme) I got the
same error but it was fatal.

Let me know if you want a trace.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#4

Tom,

Quote:

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)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#5

Quote:

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 that get_share_directory() is returning /usr/share; which does
not make a lot of sense. I think you must have used nondefault
configuration settings for the installation location (--prefix and
friends) ... so the above answer is not very helpful.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

#6

Tom,

Quote:

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 settings for the installation location (--prefix and
friends) ... so the above answer is not very helpful.

Nope:
$ ./configure --with-perl --with-odbc

One nonstandard thing about the target locations was that /usr/local/pgsql is
a mount and not an ordinary directory. Dunno how that could make PG lose
the libdir, though.

Will send you the full config.log when I'm back in my office and can retrieve
it.

--Josh

--
__Aglio Database Solutions_______________
Josh Berkus Consultant
josh (AT) agliodbs (DOT) com www.agliodbs.com
Ph: 415-752-2500 Fax: 415-752-2387
2166 Hayes Suite 200 San Francisco, CA

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#7

Josh Berkus <josh (AT) agliodbs (DOT) com> writes:

Quote:

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:
$ ./configure --with-perl --with-odbc

One nonstandard thing about the target locations was that /usr/local/pgsql is
a mount and not an ordinary directory. Dunno how that could make PG lose
the libdir, though.

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?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

#8

Tom,

Quote:

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 would think:

-- Symlinking the PostgreSQL binaries may cause problems with PostgreSQL
locating libraries and files, due to changes to make moving Postgres
directories easier. It is recommended that you use --exec-prefix when
compiling if you think you will need symlinks.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#9

Tom,

Quote:

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? =C2=A0Where does t=
hat
mount point to, anyway?

Yes, there are symlinks in /usr/bin to /usr/local/pgsql/bin. I've never h=
ad=20
it cause issues before, though. Hmmmm ... did I maybe do hardlinks instead=
=20
of symlinks? Better check.

The mount points to a SAN filesystem.

--Josh

--=20
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#10

Tom Lane wrote:

Quote:

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 in private directory trees and then symlinking
the relevant parts to shared locations. Also, sites using AFS file
systems do things of that kind. I hope these systems aren't going to
be broken completely.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)