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*
