Re: psql: error: could not connect to server: Connection refused

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: BeeRich Lists <bee(dot)lists(at)gmail(dot)com>
Cc: Submit Postgresql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: psql: error: could not connect to server: Connection refused
Date: 2022-07-04 01:45:31
Message-ID: 1435901.1656899131@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

BeeRich Lists <bee(dot)lists(at)gmail(dot)com> writes:
> Hi folks. I cannot connect to my postgres server. I’ve run through all the directives and I still can’t understand why this isn’t showing up.

It sure looks like the postmaster doesn't think you told it to
listen on any TCP sockets, because if it did they'd have been
listed in the initial log output. Are you sure that this setting
is really the active one?

> listen_addresses = '*'

It could also be that there is something weird about your system
environment that is causing '*' to expand to nothing. Try
explicitly specifying '127.0.0.1, ::1' instead.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message BeeRich Lists 2022-07-04 03:21:28 Re: psql: error: could not connect to server: Connection refused
Previous Message BeeRich Lists 2022-07-04 01:06:33 psql: error: could not connect to server: Connection refused