Re: Instalación de postgres dejo de funcionar - connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"

Hola
Parece un problema de permisos del directorio de Postgres.
Revisa los permisos. Mira la línea del log que pone:

DETAIL: Permissions should be u=rwx (0700).

Saludos.

On Sat, Aug 4, 2018 at 7:31 AM, Oscar Ricardo Sánche Gutierréz <
oscarricardosan(at)gmail(dot)com> wrote:

> Hola compañer(at)s, perdón por molestar pero no se a quien recurrir.
>
> Tengo mi servidor linux con postgres 10.
>
> Lleva buen tiempo trabajando sin problema pero hoy al conectarme por ssh
> me retornaba:
>
> * ssh_exchange_identification: read: Connection reset by peer
>
> Reinicie el servidor y la base de datos ahora me retorna:
>
> forge(at)CourierApp-Mensajero1:~$ psql
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>
> Ya corrí
> * sudo systemctl start postgresql
> * sudo systemctl enable postgresql
>
> Pero el error persiste :(
>
> Esto me retorna:
>
> *systemctl status postgresql(at)10-main(dot)service*
> ● postgresql(at)10-main(dot)service - PostgreSQL Cluster 10-main
> Loaded: loaded (/lib/systemd/system/postgresql(at)(dot)service; disabled;
> vendor preset: enabled)
> Active: failed (Result: resources) since Sat 2018-08-04 04:58:54 UTC;
> 19min ago
> Process: 3594 ExecStart=/usr/bin/pg_ctlcluster
> --skip-systemctl-redirect %i start (code=exited, status=1/FAILURE)
>
> *sudo journalctl -xe -q*
> Aug 04 05:28:49 CourierApp-Mensajero1 sshd[3896]: Disconnected from
> 144.217.83.0 port 46592 [preauth]
> Aug 04 05:28:50 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:1b:f0:08:00 SRC=23.226.130.55
> DST=162.243.165.
> Aug 04 05:28:52 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:17:f0:08:00 SRC=41.184.233.57
> DST=162.243.165.
> Aug 04 05:29:08 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:17:f0:08:00 SRC=23.226.130.55
> DST=162.243.165.
> Aug 04 05:29:25 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:1b:f0:08:00 SRC=85.114.128.78
> DST=162.243.165.
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: forge : TTY=pts/1 ;
> PWD=/home/forge ; USER=root ; COMMAND=/usr/bin/pg_ctlcluster 10 main start
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: pam_unix(sudo:session):
> session opened for user root by forge(uid=0)
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: Starting PostgreSQL
> Cluster 10-main...
> -- Subject: Unit postgresql(at)10-main(dot)service has begun start-up
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit postgresql(at)10-main(dot)service has begun starting up.
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: Error:
> /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start
> -D /va
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]:
> 2018-08-04 05:29:35.522 UTC [3911] FATAL: data directory
> "/var/lib/postgresql/10/main"
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]:
> 2018-08-04 05:29:35.522 UTC [3911] DETAIL: Permissions should be u=rwx
> (0700).
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: pg_ctl:
> could not start server
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: Examine
> the log output.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: PID file /var/run/postgresql/10-main.pid not
> readable (yet?) after start:
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: pam_unix(sudo:session):
> session closed for user root
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: Failed to start
> PostgreSQL Cluster 10-main.
> -- Subject: Unit postgresql(at)10-main(dot)service has failed
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit postgresql(at)10-main(dot)service has failed.
> --
> -- The result is failed.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: Unit entered failed state.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: Failed with result 'resources'.
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Invalid user glassfish
> from 144.217.83.0
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: input_userauth_request:
> invalid user glassfish [preauth]
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Received disconnect from
> 144.217.83.0 port 47075:11: Normal Shutdown, Thank you for playing [preauth]
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Disconnected from
> 144.217.83.0 port 47075 [preauth]
> Aug 04 05:29:38 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:1b:f0:08:00 SRC=23.226.130.55
> DST=162.243.165.
> Aug 04 05:30:06 CourierApp-Mensajero1 sudo[3917]: forge : TTY=pts/1 ;
> PWD=/home/forge ; USER=root ; COMMAND=/bin/journalctl -xe -q
> Aug 04 05:30:06 CourierApp-Mensajero1 sudo[3917]: pam_unix(sudo:session):
> session opened for user root by forge(uid=0)
>
> forge(at)CourierApp-Mensajero1:~$
> forge(at)CourierApp-Mensajero1:~$ sudo journalctl -xe -q
> Aug 04 05:28:52 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:17:f0:08:00 SRC=41.184.233.57
> DST=162.243.165.
> Aug 04 05:29:08 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:17:f0:08:00 SRC=23.226.130.55
> DST=162.243.165.
> Aug 04 05:29:25 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:1b:f0:08:00 SRC=85.114.128.78
> DST=162.243.165.
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: forge : TTY=pts/1 ;
> PWD=/home/forge ; USER=root ; COMMAND=/usr/bin/pg_ctlcluster 10 main start
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: pam_unix(sudo:session):
> session opened for user root by forge(uid=0)
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: Starting PostgreSQL
> Cluster 10-main...
> -- Subject: Unit postgresql(at)10-main(dot)service has begun start-up
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit postgresql(at)10-main(dot)service has begun starting up.
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: Error:
> /usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start
> -D /va
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]:
> 2018-08-04 05:29:35.522 UTC [3911] FATAL: data directory
> "/var/lib/postgresql/10/main"
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]:
> 2018-08-04 05:29:35.522 UTC [3911] DETAIL: Permissions should be u=rwx
> (0700).
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: pg_ctl:
> could not start server
> Aug 04 05:29:35 CourierApp-Mensajero1 postgresql(at)10-main[3903]: Examine
> the log output.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: PID file /var/run/postgresql/10-main.pid not
> readable (yet?) after start:
> Aug 04 05:29:35 CourierApp-Mensajero1 sudo[3898]: pam_unix(sudo:session):
> session closed for user root
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: Failed to start
> PostgreSQL Cluster 10-main.
> -- Subject: Unit postgresql(at)10-main(dot)service has failed
> -- Defined-By: systemd
> -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
> --
> -- Unit postgresql(at)10-main(dot)service has failed.
> --
> -- The result is failed.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: Unit entered failed state.
> Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]:
> postgresql(at)10-main(dot)service: Failed with result 'resources'.
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Invalid user glassfish
> from 144.217.83.0
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: input_userauth_request:
> invalid user glassfish [preauth]
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Received disconnect from
> 144.217.83.0 port 47075:11: Normal Shutdown, Thank you for playing [preauth]
> Aug 04 05:29:36 CourierApp-Mensajero1 sshd[3914]: Disconnected from
> 144.217.83.0 port 47075 [preauth]
> Aug 04 05:29:38 CourierApp-Mensajero1 kernel: [UFW BLOCK] IN=eth0 OUT=
> MAC=92:0d:fa:2c:2c:b8:cc:e1:7f:a8:1b:f0:08:00 SRC=23.226.130.55
> DST=162.243.165.
> Aug 04 05:30:06 CourierApp-Mensajero1 sudo[3917]: forge : TTY=pts/1 ;
> PWD=/home/forge ; USER=root ; COMMAND=/bin/journalctl -xe -q
> Aug 04 05:30:06 CourierApp-Mensajero1 sudo[3917]: pam_unix(sudo:session):
> session opened for user root by forge(uid=0)
> Aug 04 05:30:09 CourierApp-Mensajero1 sudo[3917]: pam_unix(sudo:session):
> session closed for user root
> Aug 04 05:30:11 CourierApp-Mensajero1 sudo[3920]: forge : TTY=pts/1 ;
> PWD=/home/forge ; USER=root ; COMMAND=/bin/journalctl -xe -q
>
>
> --
> --
> Saludos:
> *Oscar Sánchez *
> Web Developer
> C : 320 319 79 29
> oscarricardosan(at)gmail(dot)com
> <http://savne.net/>
>
> *Si no sientes lo que haces para que pierdes el tiempo*
>
>
>