Re: Connection errors in PostgreSQL 9.3.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Connection errors in PostgreSQL 9.3.2
Date
Msg-id 5615.1392933254@sss.pgh.pa.us
Whole thread Raw
In response to Re: Connection errors in PostgreSQL 9.3.2  (<fburgess@radiantblue.com>)
List pgsql-bugs
[ 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



pgsql-bugs by date:

Previous
From:
Date:
Subject: Re: Connection errors in PostgreSQL 9.3.2
Next
From:
Date:
Subject: Re: Connection errors in PostgreSQL 9.3.2