Re: BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing

From: Matti Linnanvuori <matti(dot)linnanvuori(at)portalify(dot)com>
To: poudelpratik97(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing
Date: 2022-01-25 11:38:00
Message-ID: CA9C8A96-5315-4AE6-B6F6-548796424139@portalify.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 25. Jan 2022, at 4.28, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 17381
> Logged by: Pratik Poudel
> Email address: poudelpratik97(at)gmail(dot)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. with command systemctl start.

Best regards, Matti Linnanvuori

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-01-26 08:25:20 BUG #17382: When vacuum full or vacuumdb - F is executed, a large number of empty files will be generated in the
Previous Message PG Bug reporting form 2022-01-25 02:28:19 BUG #17381: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" After installing