From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Antonio Silva <aolinto(dot)lst(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: could not connect to server |
Date: | 2016-10-16 13:49:46 |
Message-ID: | f7e205a1-e6ab-ea0a-156b-7d87f4fe93e2@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
I would look in the the /var/log/apt/history.log.* files that cover
Friday and see what upgraded. That may offer a clue.
>
> Well, but I have my database available now. Thanks.
>
> Best regards,
>
> Antônio Olinto
>
> 2016-10-15 14:28 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>
> On 10/15/2016 10:11 AM, Antonio Silva wrote:
>
> Hello
>
> I'm using postgres 9.5 on Ubuntu 16.04. I have worked with pg in my
> notebook for almost a month but today postgres did not connected. I
> tryed both PGAdmin and psql.
>
>
> Did you do an apt-get upgrade in the interim?
>
>
> I also tried to login using my own user and postgres but I
> received the
> messages:
>
> Server doesn't listen
> The server doesn't accept connections: the connection library
> reports
> could not connect to server: Conexão recusada (connection
> refused) Is
> the server running on host "127.0.0.1" and accepting TCP/IP
> connections
> on port 5432?
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Sebastian Luque | 2016-10-16 13:51:10 | Re: custom average window function failure |
Previous Message | Andreas Seltenreich | 2016-10-16 10:54:49 | Re: Query generator |