public inbox for [email protected]
help / color / mirror / Atom feedFrom: BeeRich Lists <[email protected]>
To: Tom Lane <[email protected]>
Cc: Submit Postgresql Novice <[email protected]>
Subject: Re: psql: error: could not connect to server: Connection refused
Date: Sun, 3 Jul 2022 23:21:28 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
Oops, a re-reply:
Hi Tom. Thanks for the reply.
That’s what I’m thinking as it’s not showing up. However I have told it to listen on '*'. Here are relevant settings:
port | 5432 | Sets the TCP port the server listens on.
tcp_keepalives_count | 0 | Maximum number of TCP keepalive retransmits.
tcp_keepalives_idle | 0 | Time between issuing TCP keepalives.
tcp_keepalives_interval | 0 | Time between TCP keepalive retransmits.
tcp_user_timeout | 0 | TCP user timeout.
unix_socket_directories | /var/run/postgresql, /tmp | Sets the directories where Unix-domain sockets will be created.
unix_socket_group | | Sets the owning group of the Unix-domain socket.
unix_socket_permissions | 0777 | Sets the access permissions of the Unix-domain socket.
listen_addresses | * | Sets the host name or IP address(es) to listen to.
Other than that I’m not sure how to turn that on. BTW those items come from `show all;`. In my postgresql.conf I have this:
listen_addresses = '*' # what IP address(es) to listen on;
Oh look at this…I changed that out as you expected, as well as its static IP on the LAN, and this showed up on restart:
Jul 03 22:58:58 server_n.project33.ca postmaster[2534]: 2022-07-03 22:58:58.720 EDT [2534] LOG: listening on IPv4 address "192.168.1.23", port 5432
Jul 03 22:58:58 server_n.project33.ca postmaster[2534]: 2022-07-03 22:58:58.720 EDT [2534] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Jul 03 22:58:58 server_n.project33.ca postmaster[2534]: 2022-07-03 22:58:58.728 EDT [2534] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
More testing…
OK so it seems on the machine, the port is open (nmap localhost, nmap box.local, nmap <LAN IP address>, but it is not showing up on my workstation for some reason. But I think I found out why:
Not shown: 5474 filtered tcp ports (no-response), 26 filtered tcp ports (admin-prohibited)
admin-prohibited? Port 5432 is showing up on that machine, but not on my workstation. So the firewall is active, and here’s the firewall list:
$ sudo firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: enp0s25
sources:
services: cockpit dhcpv6-client ssh
ports:
protocols:
forward: yes
masquerade: no
forward-ports:
source-ports:
icmp-blocks:
rich rules:
It seems I need to add postgresql as a `service`. `firewall-cmd --get-services` shows postgresql as a service.
It worked! It was the firewall that needed a port hole poked in it. This is what I did:
$ sudo firewall-cmd --zone=public --permanent --add-service=postgresql
$ sudo firewall-cmd --zone=public --permanent --add-port 5432/tcp
$ sudo firewall-cmd --reload
$ sudo firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: enp0s25
sources:
services: cockpit dhcpv6-client postgresql ssh
ports: 5432/tcp
protocols:
forward: yes
masquerade: no
forward-ports:
source-ports:
icmp-blocks:
rich rules:
And I can get in using psql as well.
Well done, Tom!
Cheers, Bee
> On Jul 3, 2022, at 9:45 PM, Tom Lane <[email protected]> wrote:
>
> BeeRich Lists <[email protected]> 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
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: psql: error: could not connect to server: Connection refused
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox