Connection errors in PostgreSQL 9.3.2
<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>PostgreSQL version: 9.3.2<br>Operating system: RHEL 6.4<br>
Description: </div><div><br></div><div>Hello PostgreSQL developers</div><div><br></div><div>We are getting the following error trying to connect to PostgreSQL even though I commented out the <b>timezone</b> and <b>log_timezone</b> settings in the postgresql.conf file.</div><div><br></div><div><b>Invalid value for parameter "Timezone": "Etc/GMT"</b></div><div><br></div><div>Does anyone know how to fix this?</div><div><br></div><div>thanks</div><div><br></div></span></body></html>
On Wed, Feb 19, 2014 at 2:00 PM, <fburgess@radiantblue.com> wrote:
We are getting the following error trying to connect to PostgreSQL even
though I commented out the *timezone* and *log_timezone* settings in the
postgresql.conf file.*Invalid value for parameter "Timezone": "Etc/GMT"*
Does anyone know how to fix this?
Did you reload the postgresql.conf file after the change? If so, perhaps it
is set at the role level? What does the following show: "select
rolname,rolconfig from pg_roles;"
bricklen <bricklen@gmail.com> writes:
On Wed, Feb 19, 2014 at 2:00 PM, <fburgess@radiantblue.com> wrote:
We are getting the following error trying to connect to PostgreSQL even
though I commented out the *timezone* and *log_timezone* settings in the
postgresql.conf file.
*Invalid value for parameter "Timezone": "Etc/GMT"*
Does anyone know how to fix this?
Did you reload the postgresql.conf file after the change? If so, perhaps it
is set at the role level? What does the following show: "select
rolname,rolconfig from pg_roles;"
If the complaint is showing up at connection time then the setting is not
coming from postgresql.conf. Aside from role or database settings, it
could be that the client side is trying to set it (perhaps due to a PGTZ
environment variable).
The other angle that is worth considering is why isn't that value
considered valid? It works for me. Perhaps you have an incomplete
share/timezone directory, or if you built with --with-system-tzdata,
maybe the directory that points to is incomplete.
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
<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@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>><br>
Date: Wed, February 19, 2014 4:44 pm<br>
To: bricklen <<a href="mailto:bricklen@gmail.com">bricklen@gmail.com</a>><br>
Cc: <a href="mailto:fburgess@radiantblue.com">fburgess@radiantblue.com</a>, <a href="mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org</a><br>
<br>
bricklen <<a href="mailto:bricklen@gmail.com">bricklen@gmail.com</a>> writes:<br>
> On Wed, Feb 19, 2014 at 2:00 PM, <<a href="mailto:fburgess@radiantblue.com">fburgess@radiantblue.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@postgresql.org">pgsql-bugs@postgresql.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>
Import Notes
Resolved by subject fallback
[ 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
<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@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>><br>
Date: Thu, February 20, 2014 2:54 pm<br>
To: <a href="mailto:fburgess@radiantblue.com">fburgess@radiantblue.com</a><br>
Cc: "bricklen" <<a href="mailto:bricklen@gmail.com">bricklen@gmail.com</a>>, <a href="mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org</a><br>
<br>
[ please don't post html-only mail to these lists ]<br>
<br>
<<a href="mailto:fburgess@radiantblue.com">fburgess@radiantblue.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@postgresql.org">pgsql-bugs@postgresql.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>
Import Notes
Resolved by subject fallback