Thread: BUG #16278: SOCKET ISSUE

BUG #16278: SOCKET ISSUE

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      16278
Logged by:          Uday Spellbound
Email address:      uday.spellbound@gmail.com
PostgreSQL version: 9.5.19
Operating system:   UBUNTU 16.04 LTS
Description:

could not connect to database template1: 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"?


Re: BUG #16278: SOCKET ISSUE

From
Daniel Gustafsson
Date:
> On 26 Feb 2020, at 08:03, PG Bug reporting form <noreply@postgresql.org> wrote:

> could not connect to database template1: 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"?

This report doesn't contain enough information to say anything about what is
going on.  Please provide information on what you did to reach this state, and
why you expected the connection to work.

cheers ./daniel


Re: BUG #16278: SOCKET ISSUE

From
Daniel Gustafsson
Date:
> On 26 Feb 2020, at 08:23, Uday Malaviya <uday.spellbound@gmail.com> wrote:

Please keep the list on CC:

> I am Using Godady Server Where installed Ubuntu 16.0.4 and postgres 9.5.19 with Odoo Version 10 community.
>
> after 2 years i restart the postgres and odoo server after that this issue is coming.
> could not connect to database template1: 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"?

That's still not enough information, what does the logfile say about the
restart?  Is the postgres process running?

cheers ./daniel


Re: BUG #16278: SOCKET ISSUE

From
Daniel Gustafsson
Date:
> On 26 Feb 2020, at 08:42, Uday Malaviya <uday.spellbound@gmail.com> wrote:

Again, please keep the list on CC:

> POstgres Service is Start but after 2 mins the service is down
> and the 5432 socket error is come

And what does the logfile say?

> On Wed, 26 Feb 2020 at 13:10, Daniel Gustafsson <daniel@yesql.se> wrote:
> > On 26 Feb 2020, at 08:23, Uday Malaviya <uday.spellbound@gmail.com> wrote:
>
> Please keep the list on CC:
>
> > I am Using Godady Server Where installed Ubuntu 16.0.4 and postgres 9.5.19 with Odoo Version 10 community.
> >
> > after 2 years i restart the postgres and odoo server after that this issue is coming.
> > could not connect to database template1: 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"?
>
> That's still not enough information, what does the logfile say about the
> restart?  Is the postgres process running?