Thanks Tom!! would not have found this solution without your suggestions.

-------- Original Message --------
Subject: Re: [BUGS] Connection errors in PostgreSQL 9.3.2
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu, February 20, 2014 2:54 pm
To: fburgess@radiantblue.com
Cc: "bricklen" <bricklen@gmail.com>, pgsql-bugs@postgresql.org

[ 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/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
> /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


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs