Обсуждение: pg_isready mandatory parameters?
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
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
"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