Re: Connection errors in PostgreSQL 9.3.2
| От | |
|---|---|
| Тема | Re: Connection errors in PostgreSQL 9.3.2 |
| Дата | |
| Msg-id | 20140220153953.5a830134ae84016b0174832fdc1a3173.8f92ef4ea0.wbe@email11.secureserver.net обсуждение исходный текст |
| Ответ на | Connection errors in PostgreSQL 9.3.2 (<fburgess@radiantblue.com>) |
| Список | pgsql-bugs |
<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
В списке pgsql-bugs по дате отправления: