Обсуждение: BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing
BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing
От
PG Bug reporting form
Дата:
The following bug has been logged on the website:
Bug reference: 17381
Logged by: Pratik Poudel
Email address: poudelpratik97@gmail.com
PostgreSQL version: 14.0
Operating system: Linux- Ubuntu
Description:
Hello,
I tried to install postgresql on Ubuntu 20 LTS.
I followed digital oceans docs and used the following for the
installation::
sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
This installed successfully when I tried to switch to postgres account
using
sudo su - postgres
The above worked.
But it throws the error when i try the command "psql"
psql: error: connection to server on socket
"/var/run/postgresql/.s.PGSQL.5432"
failed: No such file or directory
Is the server running locally and accepting connections on that socket?
> On 25. Jan 2022, at 4.28, PG Bug reporting form <noreply@postgresql.org> wrote: > > The following bug has been logged on the website: > > Bug reference: 17381 > Logged by: Pratik Poudel > Email address: poudelpratik97@gmail.com > PostgreSQL version: 14.0 > Operating system: Linux- Ubuntu > Description: > > Hello, > I tried to install postgresql on Ubuntu 20 LTS. > I followed digital oceans docs and used the following for the > installation:: > sudo apt-get update > sudo apt-get install postgresql postgresql-contrib > > This installed successfully when I tried to switch to postgres account > using > sudo su - postgres > The above worked. > But it throws the error when i try the command "psql" > > psql: error: connection to server on socket > "/var/run/postgresql/.s.PGSQL.5432" > failed: No such file or directory > Is the server running locally and accepting connections on that socket? > Hello! I don't think Ubuntu starts the PostgreSQL server with those commands. You should set up and then start PostgreSQL e.g. withcommand systemctl start. Best regards, Matti Linnanvuori