<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>
<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: Wed, February 19, 2014 4:44 pm<br>
To: bricklen <<a href="mailto:bricklen(at)gmail(dot)com">bricklen(at)gmail(dot)com</a>><br>
Cc: <a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>, <a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a><br>
<br>
bricklen <<a href="mailto:bricklen(at)gmail(dot)com">bricklen(at)gmail(dot)com</a>> writes:<br>
> On Wed, Feb 19, 2014 at 2:00 PM, <<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>> wrote:<br>
>> We are getting the following error trying to connect to PostgreSQL even<br>
>> though I commented out the *timezone* and *log_timezone* settings in the<br>
>> <a href="http://postgresql.conf">postgresql.conf</a> file.<br>
>> *Invalid value for parameter "Timezone": "Etc/GMT"*<br>
>> Does anyone know how to fix this?<br>
<br>
> Did you reload the <a href="http://postgresql.conf">postgresql.conf</a> file after the change? If so, perhaps it<br>
> is set at the role level? What does the following show: "select<br>
> rolname,rolconfig from pg_roles;"<br>
<br>
If the complaint is showing up at connection time then the setting is not<br>
coming from <a href="http://postgresql.conf">postgresql.conf</a>. Aside from role or database settings, it<br>
could be that the client side is trying to set it (perhaps due to a PGTZ<br>
environment variable).<br>
<br>
The other angle that is worth considering is why isn't that value<br>
considered valid? It works for me. Perhaps you have an incomplete<br>
share/timezone directory, or if you built with --with-system-tzdata,<br>
maybe the directory that points to is incomplete.<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>