PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15586
PG Version10.6
OSUbuntu 18.04
Opened2019-01-10 11:15:45+00
Reported byNoyal Claiton
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15586
Logged by:          Noyal Claiton
Email address:      (redacted)
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@10-main
below error message pops-out

‚óŹ postgresql@10-main.service - PostgreSQL Cluster 10-main
   Loaded: loaded (/lib/systemd/system/postgresql@.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@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@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@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@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@10-main[7733]: pg_ctl: could
not start server
Jan 10 16:21:58 ubuntu-VirtualBox postgresql@10-main[7733]: Examine the log
output.
Jan 10 16:21:58 ubuntu-VirtualBox systemd[1]: postgresql@10-main.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@10-main.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

Messages

DateAuthorSubject
2019-01-10 11:15:45+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15586: Failed to start PostgreSQL Cluster 10-main