<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Thanks Tom!! would not have found this solution without your suggestions.<br><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [BUGS] Connection errors in PostgreSQL 9.3.2<br>
From: Tom Lane <<a href="mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us">tgl(at)sss(dot)pgh(dot)pa(dot)us</a>><br>
Date: Thu, February 20, 2014 2:54 pm<br>
To: <a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a><br>
Cc: "bricklen" <<a href="mailto:bricklen(at)gmail(dot)com">bricklen(at)gmail(dot)com</a>>, <a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a><br>
<br>
[ please don't post html-only mail to these lists ]<br>
<br>
<<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>> writes:<br>
> <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/timezone directory.</div><div><br></div><div>There are 252 entries in our old obsolete PostgreSQL 9.1.6 /opt/PostgreSQL/9.1/share/postgresql/timezone directory.</div><div><br></div><div>I checked the permissions in the <br>
> /opt/PostgreSQL/9.3/share/postgresql/timezone and they were set to 600. I<br>
> cross-checked these against a 9.1 instance we have running on another box and the <br>
> permissions were 644 could this be the issue?</div><div><br></div><div>thanks</div><div><br></div><br>
<br>
If the timezone files aren't owned by the same user ID that's running the<br>
server process, then yeah, those permissions could be the problem. There<br>
should be no harm in making them world-readable in any case.<br>
<br>
regards, tom lane<br>
<br>
<br>
-- <br>
Sent via pgsql-bugs mailing list (<a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-bugs">http://www.postgresql.org/mailpref/pgsql-bugs</a><br>
</div>
</blockquote></span></body></html>