Обсуждение: 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