pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_isready mandatory parameters?
3+ messages / 3 participants
[nested] [flat]
* pg_isready mandatory parameters?
@ 2022-11-11 17:09 Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
2022-11-11 17:21 ` Re: pg_isready mandatory parameters? Jeffrey Walton <noloader@gmail.com>
2022-11-11 17:27 ` Re: pg_isready mandatory parameters? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Zwettler Markus (OIZ) @ 2022-11-11 17:09 UTC (permalink / raw)
To: pgsql-general
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?
Thanks,
Markus
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_isready mandatory parameters?
2022-11-11 17:09 pg_isready mandatory parameters? Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
@ 2022-11-11 17:21 ` Jeffrey Walton <noloader@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jeffrey Walton @ 2022-11-11 17:21 UTC (permalink / raw)
To: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>; +Cc: pgsql-general
On Fri, Nov 11, 2022 at 12:09 PM Zwettler Markus (OIZ)
<Markus.Zwettler@zuerich.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_isready mandatory parameters?
2022-11-11 17:09 pg_isready mandatory parameters? Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
@ 2022-11-11 17:27 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2022-11-11 17:27 UTC (permalink / raw)
To: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>; +Cc: pgsql-general
"Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch> writes:
> I always thought all parameters are optional? No?
They're optional, but maybe there is something wrong with
the default values (wherever you're getting those from).
pg_isready isn't really chartered to tell you about that,
but I wonder what you get from psql with the same command
line option sets.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-11-11 17:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-11 17:09 pg_isready mandatory parameters? Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
2022-11-11 17:21 ` Jeffrey Walton <noloader@gmail.com>
2022-11-11 17:27 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox