Re: Connection errors in PostgreSQL 9.3.2

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