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

From: Oscar Ricardo Sánche Gutierréz <oscarricardosan(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Instalación de postgres dejo de funcionar - connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"
Date: 2018-08-04 05:31:42
Message-ID: CAMT9OdG1MevYfou-1FP+UcD7nD4AFQFyZV46KQ+D5Rdj6mmpLQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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*

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Lucas Luengas 2018-08-04 13:29:05 Re: Instalación de postgres dejo de funcionar - connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"
Previous Message Kernel 2018-08-03 08:06:32 Re: pldbgapi extension para postgres 10?