From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Antonio Silva <aolinto(dot)lst(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: could not connect to server |
Date: | 2016-10-15 17:28:53 |
Message-ID: | a7b80a87-9869-54eb-83c6-1b0f773ecdec@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
This is indication that Postgres server is not running which is
confirmed by your pg_lsclusters output below.
>
> ~$ psql database
> WARNING: password file "/home/antonio/.pgpass" has group or world
> access; permissions should be u=rw (0600) or less
> psql: could not connect to server: Arquivo ou diretório não encontrado
> (File or directory not found)
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>
> $ pg_lsclusters
> Ver Cluster Port Status Owner Data directory Log file
> 9.5 main 5432 down postgres /var/lib/postgresql/9.5/main
> /var/log/postgresql/postgresql-9.5-main.log
>
> It was the first time I received the warning "password file
> "/home/antonio/.pgpass" has group or world access; permissions should be
> u=rw (0600) or less" and I fixed it:
> -rw------- 1 antonio antonio 137 Set 30 18:50 .pgpass
>
> I had edited postgresql.conf and pg_hba.conf but this morning they were
> in their original configuration. So I edited again to:
>
> /etc/postgresql/9.5/main/postgresql.conf
>
> # - Connection Settings -
> listen_addresses = '*'
> port = 5432
>
> /etc/postgresql/9.5/main/pg_hba.conf
>
> # Database administrative login by Unix domain socket
> local all postgres md5
> # TYPE DATABASE USER ADDRESS METHOD
> # "local" is for Unix domain socket connections only
> local all all md5
> # IPv4 local connections:
> host all all 127.0.0.1/32
> <http://127.0.0.1/32> md5
>
> I also restarted the server (/etc/init.d/postgresql restart) and the
> computer.
What does pg_lsclusters show?
How did you try to connect?
>
> I really appreciate any guidance.
>
> All the best,
>
> Antônio Olinto
> São Paulo, Brasil
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-10-15 17:33:08 | Re: could not connect to server |
Previous Message | Antonio Silva | 2016-10-15 17:11:01 | could not connect to server |