From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | for(dot)ggame(dot)playing(at)gmail(dot)com |
Subject: | BUG #16537: could not connect to database although database is running |
Date: | 2020-07-13 19:29:02 |
Message-ID: | 16537-46c4c7484e5d6b42@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16537
Logged by: William Frezno
Email address: for(dot)ggame(dot)playing(at)gmail(dot)com
PostgreSQL version: 12.3
Operating system: Parrot GNU/Linux 4.10
Description:
here is /var/log/postgresql/postgresql-12-main.log
2020-07-13 18:07:02.049 UTC [1092] FATAL: could not load server certificate
file "/etc/ssl/certs/ssl-cert-snakeoil.pem": No such file or directory
2020-07-13 18:07:02.050 UTC [1092] LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.
#systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; disabled;
vendor p>
Active: active (exited) since Mon 2020-07-13 22:07:02 +04; 1h 19min
ago
Process: 1095 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 1095 (code=exited, status=0/SUCCESS)
July 13 22:07:02 computer systemd[1]: Starting PostgreSQL RDBMS...
July 13 22:07:02 computer systemd[1]: Finished PostgreSQL RDBMS.
#psql
psql: error: could not connect to server: 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"?
And I see port 5432 enabled on /etc/postgresql/12/main/postgresql.conf
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
What's wrong with postgresql server?
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-07-13 19:50:17 | Re: BUG #16537: could not connect to database although database is running |
Previous Message | Pavel Stehule | 2020-07-13 18:27:25 | Re: Small query using LATERAL that segfaults Postgres |