pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_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>
  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:21  Jeffrey Walton <noloader@gmail.com>
  parent: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
  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:27  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
  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