Re: pg_isready mandatory parameters?

From: Jeffrey Walton <noloader(at)gmail(dot)com>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_isready mandatory parameters?
Date: 2022-11-11 17:21:58
Message-ID: CAH8yC8m0fU8xVtJzwHZg5Ac5j1PN6wKTbhLfi9wm9o1JsD-fww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 11, 2022 at 12:09 PM Zwettler Markus (OIZ)
<Markus(dot)Zwettler(at)zuerich(dot)ch> wrote:
>
> I found this in PG14 è
>
> bash-4.4$ ./pg_isready --version
>
> pg_isready (PostgreSQL) 14.2
>
> bash-4.4$ ./pg_isready
>
> /var/run/postgresql:5432 - no attempt
>
> bash-4.4$ ./pg_isready -h localhost
>
> localhost:5432 - no attempt
>
> bash-4.4$ ./pg_isready -h localhost -p 5432
>
> localhost:5432 - no attempt
>
> bash-4.4$ ./pg_isready -h localhost -p 5432 -d postgres
>
> localhost:5432 - no attempt
>
> bash-4.4$ ./pg_isready -h localhost -p 5432 -d postgres -U postgres
>
> localhost:5432 - accepting connections
>
> I always thought all parameters are optional? No?

Optional or ignored???

This may be more what you are looking for:
https://github.com/noloader/pg_check_conn

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-11-11 17:27:46 Re: pg_isready mandatory parameters?
Previous Message Alexis Zapata 2022-11-11 17:09:27 Table : Bloat grow high