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 < oscarricardo...@gmail.com> wrote: > Hola compañer@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@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@10-main.service* > ● postgresql@10-main.service - PostgreSQL Cluster 10-main > Loaded: loaded (/lib/systemd/system/postgresql@.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@10-main.service has begun start-up > -- Defined-By: systemd > -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel > -- > -- Unit postgresql@10-main.service has begun starting up. > Aug 04 05:29:35 CourierApp-Mensajero1 postgresql@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@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@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@10-main[3903]: pg_ctl: > could not start server > Aug 04 05:29:35 CourierApp-Mensajero1 postgresql@10-main[3903]: Examine > the log output. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.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@10-main.service has failed > -- Defined-By: systemd > -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel > -- > -- Unit postgresql@10-main.service has failed. > -- > -- The result is failed. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.service: Unit entered failed state. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.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@CourierApp-Mensajero1:~$ > forge@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@10-main.service has begun start-up > -- Defined-By: systemd > -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel > -- > -- Unit postgresql@10-main.service has begun starting up. > Aug 04 05:29:35 CourierApp-Mensajero1 postgresql@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@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@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@10-main[3903]: pg_ctl: > could not start server > Aug 04 05:29:35 CourierApp-Mensajero1 postgresql@10-main[3903]: Examine > the log output. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.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@10-main.service has failed > -- Defined-By: systemd > -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel > -- > -- Unit postgresql@10-main.service has failed. > -- > -- The result is failed. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.service: Unit entered failed state. > Aug 04 05:29:35 CourierApp-Mensajero1 systemd[1]: > postgresql@10-main.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 > oscarricardo...@gmail.com > <http://savne.net/> > > *Si no sientes lo que haces para que pierdes el tiempo* > > >
