On 2/13/20 9:02 PM, Adrian Klaver wrote:
> 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.
Hit send to soon. At a guess the Postgres service is starting before the
drive is mounted.
>
>>
>> Thanks,
>> Jason
>>
>> --
>> Jason M. Swails
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com