Home / ubuntu / Questions / 1118644
In Process
Eric Mamet
Asked: 2019-02-16 15:37:51 +0800 CST

How to connect to postgresql 11 just installed on ubuntu?

  • 772

In the windows Linux Subsystem, I installed ubuntu 18.04

In there, I installed postgresql 11 using sudo apt-get install postgresql-11

I got this back

Ver Cluster Port Status Owner Data directory Log file 11 main 5432 down postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log

When I run "psql", I get the 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"?

Then I tried to specify a folder, like this

psql -h /var/lib/postgresql/11/main

and I get this error...

psql: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/lib/postgresql/11/main/.s.PGSQL.5432"?

Any hint?

Thanks

postgresql

1 Answers

  1. I had missed an instruction to start the server...

    It finally started with the following instruction

    sudo -u postgres /usr/lib/postgresql/11/bin/pg_ctl -D /etc/postgresql/11/main -l /var/log/postgresql/postgresql-11-main.log start
    • 1