Re: could not connect to server

On 10/15/2016 09:09 PM, Antonio Silva wrote:
> Dear Adrian and Tom, thanks for your attention.
>
> I did an upgrade on Friday. I use to do this every week.
>
> Log file informed:
>
> 2016-10-15 06:15:20 BRT [995-1] FATAL: data directory
> "/var/lib/postgresql/9.5/main" has group or world access
> 2016-10-15 06:15:20 BRT [995-2] DETAIL: Permissions should be u=rwx (0700).
>
> The problem with permissions was already indicated to .pgpass
>
> So I did a "sudo chmod 0700 main" at /var/lib/postgresql/9.5/ directory
> and I could connect postgres again!
>
> A cannot understand what happened. How an upgrade changes the
> permissions of files an folders? I work with more two desktops with the
> same framework (I7, 8 GB, Ubuntu 16.04, PostgreSQL, ...) and it did not
> happen.

In my previous post I should have also mentioned checking syslog for the
period in question.

>
> Well, but I have my database available now. Thanks.
>
> Best regards,
>
> Antônio Olinto

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com