[ please don't post html-only mail to these lists ]
<fburgess@radiantblue.com> writes:
> <html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>There are 260 entries in the
/opt/PostgreSQL/9.3/share/postgresql/timezonedirectory.</div><div><br></div><div>There are 252 entries in our old
obsoletePostgreSQL 9.1.6 /opt/PostgreSQL/9.1/share/postgresql/timezone directory.</div><div><br></div><div>I checked
thepermissions in the
> /opt/PostgreSQL/9.3/share/postgresql/timezone and they were set to 600. I
> cross-checked these against a 9.1 instance we have running on another box and the
> permissions were 644 could this be the issue?</div><div><br></div><div>thanks</div><div><br></div>
If the timezone files aren't owned by the same user ID that's running the
server process, then yeah, those permissions could be the problem. There
should be no harm in making them world-readable in any case.
regards, tom lane