From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | modelmiscreants(at)gmail(dot)com |
Subject: | BUG #15586: Failed to start PostgreSQL Cluster 10-main |
Date: | 2019-01-10 11:15:45 |
Message-ID: | 15586-d9d93385a28a77fa@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: 15586
Logged by: Noyal Claiton
Email address: modelmiscreants(at)gmail(dot)com
PostgreSQL version: 10.6
Operating system: Ubuntu 18.04
Description:
Team,
If I'm addressing this email to inappropriate mail id, kindly re-route it to
respective team.
I'm using ubuntu 18.04 and tried installing Postgresql 10, using apt-get
install postgresql
Installation went well.
When I start the service it runs fine, but when I run
$ sudo su postgres
it takes me in, when I type psql
getting the following error,
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"?
Checked for a solution all over the internet and spent almost 2 days with
this issue,
finally ran the following command
systemctl status postgresql(at)10-main
below error message pops-out
● postgresql(at)10-main(dot)service - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/postgresql(at)(dot)service; indirect; vendor
preset: enabled)
Active: failed (Result: protocol) since Thu 2019-01-10 16:21:58 IST;
17min ago
Process: 7733 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect
10-main start (code=exited, status=1/FAILURE)
Jan 10 16:21:58 ubuntu-VirtualBox systemd[1]: Starting PostgreSQL Cluster
10-main...
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: Error:
/usr/lib/postgresql/10/bin/pg_ctl /usr/lib/postgresql/10/bin/pg_ctl start -D
/var/lib/postgresql/10/main -l /var/log/postgresql/postgresql
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: 2019-01-10
16:21:58.817 IST [7738] FATAL: private key file
"/etc/ssl/private/ssl-cert-snakeoil.key" has group or world access
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: 2019-01-10
16:21:58.817 IST [7738] DETAIL: File must have permissions u=rw (0600) or
less if owned by the database user, or permissions u=rw,g=r
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: 2019-01-10
16:21:58.818 IST [7738] LOG: database system is shut down
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: pg_ctl: could
not start server
Jan 10 16:21:58 ubuntu-VirtualBox postgresql(at)10-main[7733]: Examine the log
output.
Jan 10 16:21:58 ubuntu-VirtualBox systemd[1]: postgresql(at)10-main(dot)service:
Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No
such file or directory
Jan 10 16:21:58 ubuntu-VirtualBox systemd[1]: postgresql(at)10-main(dot)service:
Failed with result 'protocol'.
Jan 10 16:21:58 ubuntu-VirtualBox systemd[1]: Failed to start PostgreSQL
Cluster 10-main.
Kindly help me out.
Thank you in advance!
Regards,
Noyal
8754409574
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2019-01-10 11:44:13 | Re: Is temporary functions feature official/supported? Found some issues with it. |
Previous Message | AP | 2019-01-10 10:40:54 | Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space |