Re: Connection errors in PostgreSQL 9.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fburgess(at)radiantblue(dot)com
Cc: "bricklen" <bricklen(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Connection errors in PostgreSQL 9.3.2
Date: 2014-02-20 21:54:14
Message-ID: 5615.1392933254@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

[ please don't post html-only mail to these lists ]

<fburgess(at)radiantblue(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Steven Canova 2014-02-20 22:22:14 Is there a Support Platforms document more current that this?
Previous Message Remi Gacogne 2014-02-20 20:17:22 Re: BUG #9296: Symbol resolution issue: undefined symbol: CheckFunctionValidatorAccess