Re: a stop job is running for postgresql cluster 11-main

I am not too sure of this.

PostgreSQL: Documentation: devel: 23.6. Tablespaces
<https://www.postgresql.org/docs/devel/manage-ag-tablespaces.html>
<https://www.postgresql.org/docs/devel/manage-ag-tablespaces.html>
if the mounted shares had any issues, postgresql server might be
waiting for them for a clean shutdown and hence stuck.

but reboot forced shutdown and hence you could connect after reboot.

Maybe you can share what do you see in postgresql server logs when you
tried to shutdown manually.

Thanks,
Vijay

On Fri, 30 Apr 2021 at 20:15, Henry Francisco Garcia Cortez <
garcortez(at)gmail(dot)com> wrote:

> Greetings I have version 11 of postgresql, it is running on ubuntu server
> 18.04 LTS on virtual machine, my main issue was hard disk wasn't recognized
> for the server also I couldn't connect locally to postgresql the message
> said that a stop job is running for postgresql I want to know if is
> possible a process's postgresql that last much time could throw away the
> daemon of postgresql
>
>
> [image: Server 39.82.jpeg]
>
>
> El vie, 30 abr 2021 a las 2:32, Vijaykumar Jain (<
> vijaykumarjain(dot)github(at)gmail(dot)com>) escribió:
>
>> This is a very open ended issue :)
>>
>> Ideally if you could confirm that
>>
>> 1) were you able to connect locally on the machine via psql on loopback
>> (localhost) if it was allowed?
>> 2) did logs emit any messages when trying to connect to the server?
>> 3) if you have admin access to server, can you look at dmesg -a output on
>> the reboot. If you mention you had issues with connecting even after
>> restarting postgresql server, but it was fine after a reboot maybe the
>> network interface had some issues. Do you see packet loss on the interface
>> you are connecting to?
>> 4) are there any monitoring enabled or replication enabled for this
>> server ? Were they active or broken while the time you had issues
>> connecting to the server?
>> 5) are you connecting to the server directly or via pgbouncer or other
>> layers ?
>>
>> What version of postgresql
>>
>> What client ( from my exp old npgsql clients had some bugs )
>>
>> Where is it running? Cloud vm, docker ?
>>
>>
>>
>> Thanks,
>> Vijay
>>
>> On Fri, Apr 30, 2021, 1:19 AM Henry Francisco Garcia Cortez <
>> garcortez(at)gmail(dot)com> wrote:
>>
>>> Hi community greetings for everyone this morning I couldn't connect to
>>> postgresql but the daemon of postgresql was running, so I restarted the
>>> daemon of postgresql what happened nothing, so I decided to reboot server
>>> and while server was starting it showed a message a top job is running
>>> for postgresql Cluster after that I could connect to postgresql, I want
>>> to know some idea why couldn't I connect to postgresql? and I want some
>>> advices for avoiding that situation again
>>>
>>> --
>>> Ing. Henry G. Cortez
>>>
>>>
>>>
>>>
>
> --
> Ing. Henry G. Cortez
>
>
>
>