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

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, david(dot)g(dot)johnston(at)gmail(dot)com
Subject: Re: a stop job is running for postgresql cluster 11-main
Date: 2021-04-30 08:32:40
Message-ID: CAM+6J97VLnMHq7DVwfvLsz6YmXJ_PVPuQq3k6CbVv724wWsi5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Henry Francisco Garcia Cortez 2021-04-30 14:45:11 Re: a stop job is running for postgresql cluster 11-main
Previous Message Ron 2021-04-30 03:21:22 Re: FATAL error in logs: no pb_hba.conf entry