Обсуждение: Connection errors in PostgreSQL 9.3.2
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;">PostgreSQL version: 9.3.2Operating system: RHEL 6.4=0AD= escription: Hello PostgreSQL developers</d= iv>We are getting the following error trying to connect= to PostgreSQL even though I commented out the timezone and log_t= imezone settings in the postgresql.conf file.= Invalid value for parameter "Timezone": "Etc/GMT"</di= v>Does anyone know how to fix this?thanks</d= iv>
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
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;">There are 260 entries in the /opt/PostgreSQL/9.3/share/postgresql= /timezone directory.There are 252 entries in our = old obsolete PostgreSQL 9.1.6 /opt/PostgreSQL/9.1/share/postgresql/timezone= directory.I checked the permissions in the =0A/o= pt/PostgreSQL/9.3/share/postgresql/timezone and they were set to 600. I=0A = cross-checked these against a 9.1 instance we have running on another box a= nd the =0Apermissions were 644 could this be the issue?</div= >thanks=0A<blockquote id=3D"replyBlockquote" webm= ail=3D"1" style=3D"border-left: 2px solid blue; margin-left: 8px; padding-l= eft: 8px; font-size:10pt; color:black; font-family:verdana;">=0A<div id=3D"= wmQuoteWrapper">=0A-------- Original Message --------=0ASubject: Re: [B= UGS] Connection errors in PostgreSQL 9.3.2=0AFrom: Tom Lane <<a href= =3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us>=0ADate: Wed, Fe= bruary 19, 2014 4:44 pm=0ATo: bricklen <<a href=3D"mailto:bricklen@g= mail.com">bricklen@gmail.com>=0ACc: <a href=3D"mailto:fburgess@r= adiantblue.com">fburgess@radiantblue.com, <a href=3D"mailto:pgsql-bugs@= postgresql.org">pgsql-bugs@postgresql.org=0A=0Abricklen <<a = href=3D"mailto:bricklen@gmail.com">bricklen@gmail.com> writes:= =0A> On Wed, Feb 19, 2014 at 2:00 PM, <<a href=3D"mailto:fburgess@rad= iantblue.com">fburgess@radiantblue.com> wrote:=0A>> We are= getting the following error trying to connect to PostgreSQL even=0A>= ;> though I commented out the *timezone* and *log_timezone* settings in = the=0A>> postgresql.conf f= ile.=0A>> *Invalid value for parameter "Timezone": "Etc/GMT"*= =0A>> Does anyone know how to fix this?=0A=0A> Did you rel= oad the postgresql.conf file after t= he change? If so, perhaps it=0A> is set at the role level? What does= the following show: "select=0A> rolname,rolconfig from pg_roles;"<b= r>=0A=0AIf the complaint is showing up at connection time then the sett= ing is not=0Acoming from postgresql.= conf. Aside from role or database settings, it=0Acould be that the= client side is trying to set it (perhaps due to a PGTZ=0Aenvironment v= ariable).=0A=0AThe other angle that is worth considering is why isn= 't that value=0Aconsidered valid? It works for me. Perhaps you have a= n incomplete=0Ashare/timezone directory, or if you built with --with-sy= stem-tzdata,=0Amaybe the directory that points to is incomplete.=0A= =0A=09=09=09regards, tom lane=0A=0A=0A-- =0ASent via pg= sql-bugs mailing list (pgsql-b= ugs@postgresql.org)=0ATo make changes to your subscription:=0A<= a href=3D"http://www.postgresql.org/mailpref/pgsql-bugs">http://www.postgre= sql.org/mailpref/pgsql-bugs=0A=0A=0A</bod= y>
[ 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
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;">Thanks Tom!! would not have found this solution without your sugg= estions.=0A<blockquote id=3D"replyBlockquote" webmail=3D"1" s= tyle=3D"border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; f= ont-size:10pt; color:black; font-family:verdana;">=0A<div id=3D"wmQuoteWrap= per">=0A-------- Original Message --------=0ASubject: Re: [BUGS] Connec= tion errors in PostgreSQL 9.3.2=0AFrom: Tom Lane <<a href=3D"mailto:= tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us>=0ADate: Thu, February 20, = 2014 2:54 pm=0ATo: fburgess= @radiantblue.com=0ACc: "bricklen" <<a href=3D"mailto:bricklen@gm= ail.com">bricklen@gmail.com>, <a href=3D"mailto:pgsql-bugs@postgresq= l.org">pgsql-bugs@postgresql.org=0A=0A[ please don't post html-= only mail to these lists ]=0A=0A<<a href=3D"mailto:fburgess@radi= antblue.com">fburgess@radiantblue.com> writes:=0A> <html&g= t;<body><span style=3D"font-family:Verdana; color:#000000; font-si= ze:10pt;"><div>There are 260 entries in the /opt/PostgreSQL/9.3/sh= are/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&= gt;<br></div><div>I checked the permissions in the = =0A> /opt/PostgreSQL/9.3/share/postgresql/timezone and they were set to = 600. I=0A> cross-checked these against a 9.1 instance we have runni= ng on another box and the =0A> permissions were 644 could this be th= e issue?</div><div><br></div><div>thanks</= div><div><br></div>=0A=0AIf the timezone files= aren't owned by the same user ID that's running the=0Aserver process, = then yeah, those permissions could be the problem. There=0Ashould be n= o harm in making them world-readable in any case.=0A=0A=09=09=09reg= ards, tom lane=0A=0A=0A-- =0ASent via pgsql-bugs mailing li= st (pgsql-bugs@postgresql.org<= /a>)=0ATo make changes to your subscription:=0A<a href=3D"http://ww= w.postgresql.org/mailpref/pgsql-bugs">http://www.postgresql.org/mailpref/pg= sql-bugs=0A=0A=0A