On 2/13/20 7:54 PM, Jason Swails wrote:
Hi,
I've been struggling with a strange (to me) issue for awhile. I have
PostgreSQL 11.6 installed on my Ubuntu machine with the data directory
living on a different drive than the one mounted on /. I was observing
the same behavior when my machine was running Gentoo a month ago.
The problem is that after my machine boots, I'm unable to connect to the
server from anywhere except localhost. Running a simple "systemctl
restart postgresql" fixes the problem and allows me to connect from
anywhere on my LAN. Here is an example of this behavior:
swails@client ~ $ psql -U postgres -h 192.168.1.3
psql: could not connect to server: Connection refused
Is the server running on host "192.168.1.3" and accepting
TCP/IP connections on port 5432?
swails@client ~ $ ssh 192.168.1.3
swails@server ~ $ sudo systemctl restart postgresql
swails@server ~ $ logout
Connection to 192.168.1.3 closed.
swails@client ~ $ psql -U postgres -h 192.168.1.3
Password for user postgres:
So the first connection attempt fails. But when I restart the service
and try again (doing nothing else in between), the connection attempt
succeeds. My workaround has been to simply restart the service every
time my machine reboots, but I'd really like to have a more reliable
startup.
Any ideas how to start hunting down the root cause? I think this
started happening after I moved the data directory to another drive.
I would start by looking in the system log to see what it records when
the service tries to start on reboot.
Thanks,
Jason
--
Jason M. Swails
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
