Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1otXX3-0005Eg-4N for pgsql-general@arkaria.postgresql.org; Fri, 11 Nov 2022 17:09:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1otXX1-00085m-TQ for pgsql-general@arkaria.postgresql.org; Fri, 11 Nov 2022 17:09:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1otXX1-00084d-Fb for pgsql-general@lists.postgresql.org; Fri, 11 Nov 2022 17:09:31 +0000 Received: from mx3.stadt-zuerich.ch ([194.56.33.12]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1otXWu-0002Wf-MF for pgsql-general@postgresql.org; Fri, 11 Nov 2022 17:09:31 +0000 IronPort-SDR: vTreGw0pzftIfeWQUN6qS4GaJ4XbZMwskvcC69JYft2JSVMaEueSKNimgW96sTRY+LR2p0+i68 4UKs6LrKXThPV2KSIYCH5JMwgu3t7Z9DhYd7wB5YrxHpCVl7kwoGosgS+5qjXdE6/kpZSCgoCF qTWz/Uc8LCw+jkpIBt50t2QAOwbGZ4krwq4PQmJSOb2BF+rTDWS6IPNeSPv5RZyC9GmLOZGuyS /BNgaj/+mcr5tPO8CdkVmPgI7h8thWiQeHvHzaloiwhPc5cQhBarrvlV9gB51WMi4Gbj8ehKbG qgA= X-IronPort-AV: E=Sophos;i="5.96,156,1665439200"; d="scan'208,217";a="124426995" Received: from unknown (HELO SZHM27375.global.szh.loc) ([10.7.49.70]) by mx3.prm.szh.zone with ESMTP/TLS/AES256-GCM-SHA384; 11 Nov 2022 18:09:23 +0100 Received: from SZHM27370.global.szh.loc (10.7.50.50) by SZHM27375.global.szh.loc (10.7.49.71) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.18; Fri, 11 Nov 2022 18:09:23 +0100 Received: from SZHM27370.global.szh.loc ([fe80::2839:247b:c8d4:9198]) by SZHM27370.global.szh.loc ([fe80::2839:247b:c8d4:9198%10]) with mapi id 15.01.2375.018; Fri, 11 Nov 2022 18:09:23 +0100 From: "Zwettler Markus (OIZ)" To: "pgsql-general@postgresql.org" Subject: pg_isready mandatory parameters? Thread-Topic: pg_isready mandatory parameters? Thread-Index: Adj18FfWLlOd1nOmRPCnFHZaX1aIcw== Date: Fri, 11 Nov 2022 17:09:23 +0000 Message-ID: <175a3060f7e64afab6e316529635f0a4@zuerich.ch> Accept-Language: de-CH, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.7.48.250] Content-Type: multipart/alternative; boundary="_000_175a3060f7e64afab6e316529635f0a4zuerichch_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_175a3060f7e64afab6e316529635f0a4zuerichch_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I found this in PG14 =3D=3D> 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 --_000_175a3060f7e64afab6e316529635f0a4zuerichch_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I fo= und this in PG14 è

 

 

bash= -4.4$ ./pg_isready --version

pg_i= sready (PostgreSQL) 14.2

bash= -4.4$ ./pg_isready

/var= /run/postgresql:5432 - no attempt

bash= -4.4$ ./pg_isready -h localhost

loca= lhost:5432 - no attempt

bash= -4.4$ ./pg_isready -h localhost -p 5432

loca= lhost:5432 - no attempt

bash= -4.4$ ./pg_isready -h localhost -p 5432 -d postgres

loca= lhost:5432 - no attempt

bash= -4.4$ ./pg_isready -h localhost -p 5432 -d postgres -U postgres<= /span>

loca= lhost:5432 - accepting connections

 

 

I al= ways thought all parameters are optional? No?

 

 

Than= ks,

Mark= us

 

--_000_175a3060f7e64afab6e316529635f0a4zuerichch_--