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 1m5c4E-0001tk-3C for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jul 2021 22:48:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m5c4B-000753-Q1 for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jul 2021 22:48:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m5c4B-00074v-C6 for pgsql-admin@lists.postgresql.org; Mon, 19 Jul 2021 22:48:51 +0000 Received: from sonic308-9.consmr.mail.ne1.yahoo.com ([66.163.187.32]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m5c44-0006Lg-BQ for pgsql-admin@lists.postgresql.org; Mon, 19 Jul 2021 22:48:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626734922; bh=huyfBSIKmocwAbP0FIZIOJlG+DfV3NNqI4Bo7kdoNMU=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=FpciIOjBWdC7C2bW6q1RnifgM+YTNe/uA3E9VzmXtTi8GT06HmBqCUMJGWoIbNGF1rq2BJifKVSV3a5C4LlzgaL7cHYTbPj4wgCpxLMc4pLmWc+MJOeuYQwB6+a64C5QJbWeb4qNJMASlaK4ALRieap67cNMoF+Mdo1good1ZTHVJgPKhNcjU4LRtdRArluFagZyNr/QYjzC/0Sl6Ex7M/jv45StcToMg39qs7r4RM+Y/lACGjx5KxI7C55a6cN8k5hXoZ133tQojv9aMx9Z7LR224SPwRhbkJvQRhHRSe0bfcbO70kxZK6G67PLSIQIlyUhA10JZ3BjKeB3Km4CMA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626734922; bh=WwxHEbuxq8+XKcVHOwKnJ4jOiuWaIDD6v7beRvzK8Pf=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=X6dDufjW9IQjYlWH7KjVSuAU9+sxch4+xQNNyiND0DGffdy2rLvxcibY0MC931EQZVZTPoRp5PrE/r7VadRrWWMrNEsb2LK9WWSYMYgB/X4J+dS1TBKXSuBw+psvMHmvYLuQgPquS/+oxKjVAeDXNdpuZpS58RTgxuYv+MoNgDv4aH2VX2ZVVvMgsqvIH6ePrBSFCZPxinbEbunavADb+2Rtv39WsyqQFLWcjbUpT8LB5m447ydW6q1r/n5XPnsNSM+lY+EVNF2WQMylS683fQPa9QEfqznx4KWBh/XmSpChS04aeTIdyME6q8s/VXMnvVSFfqeTSIfCC+M70WmSzQ== X-YMail-OSG: o2Tlbz4VM1mNSon0IuspYHA3B9DlNHdQH9FOBJ7cq0dips5d.XC2yC2uSVsQkPU 8vXx_m.dT6M9de0L8_Hj2kF_H4DGDHHBwnP07DeCUUQ4QrHOu92tawNuC7l8r7VjjH6rDWQF4x6X 0IwqyUko43NIwgOHhgp7J8nQxgXcYZ7EXIUWtKaArx9wJ4h3qQ9tgTjxr8rg078X679yqqAZwl8v F8tNWHh8UIcH3xA_q3mM_ywCLbv10NihP8dM_M74LgkVNmH7PRHC8DecJfJ6lr9TRckkw4GXUbda 0pX2A_.clPG3twUWNO4z0s338_AdIlZclgxN7.cSbTQV7CiG5L6IwQGadRvm6tlB8g53NUmsPKwe 4qMWINTSlTyJzC8ku_lbbL4NP2Xzc.ANJwO7sW5yFS.gJ_Cl9mmjkC.j3No4fLx40uuQVTz6quuh ZqFm6v.yDw1PCzFj5ZMtLRgs63CMeCEqGaRbbyKWq_bS8R2vZvVWOBBGvN0kTgySzr8eV4qjz8pO 94OHERHryN2Y3KF64x63PqsCQNjTOjx0xpSZ2Y5RoVECyFtGaMPt6U31JNr1Xd.yGgxBLNvoFNNT 0ZQhvpD5q.Q_V9VJ7hkdjPeHiKeuaTGymdmhUmlrm8dVya8N2DGb6NTQ2kVsR7I0lAINTreNd1pm mwpEbtYYJrDDVZzf.DWRLuE9hG1PSfxNMYvH12fV_NU4g.0DsjbwYPoyRbR8rbzkP0gwkS956i5I 6D4Bm9NNHMKV8zwid1tRTEmsuSvuyZ_8bsQud5rMzl8DIChVGjOduYAKhar8a7Meyj5zbaXPGLhp L06WkwAD2PE.temju5kyuJjZeC4.XduhkHUfUquxzTHrvJtUd8oTgvA2qZa4RnsDlBWbF4xZF7jL hlCrjiseLnlvQElg2hBBrkl.lqNWeF.0QJc7Y4lad32paP_YpbW8mpk3dvUcvagAcDKkBraUZ4xm pUc2as62FRdI_ykGFhZb5Hv8wzXESIZVcmXK_po5r5eU4UF4WSn5FrxINYPvUmxNL9lizQ5jplHh mknwlO_S90yIefkgwhDMIQGNWEdfKauHLKm9Y7X73vr2GnF1HNDcWlQle9uTCr0rGCNCyKxpT__x EId3rBNSMLklfk0GkERaJTdLMLsLg1aEiQX3qrYo5l3g9wXDxFJibujo3V1jj5X5jPLRQUx0_2Ge Xl5GVTTdw2KB78TOtWN2hALomR63BRRLaWdn7.66.qWDuf7I0xL6IRx91bcqQ9THgPzHecjCdhWe PTqH6JYeuEod8FfUaeRNSDXcdcmyBqjCh7jhFODdw46NxUG.ChpK1n0hAFP6_x6HjMdO3tPy1QRt A1Z6EodlCxkDLdP98GIrMIG8RcLDUzDukltmI.zLbbs_7RYUE454.DuPPyWtAL9ydgpAhD380aO8 MiTHUU9zaHb9N3B_oE9KpMxuDqr84NpnR5LVaZ2m5Gp5BmCZIOSSWdSu3Pfvcdv8EG7_pCUX6ZO5 PeBSzjxzu7Tjy0rUbfxa8aw0NwyVdqBCwe0OueqWnX1d5fwgXnkyUloSWQepCv6KC.Pwi9NI2NQZ GnFySYmK5dQfYXKLumJj9QFHfBg5FaIVWI3nyjaHiWMHyiAjgzbaTwzToSiM8dPMFI_eg_SLMshC 6nIvoeniPkp5nPozF1Qc6Mp.7UegBVOW9xdWCW0Auw09G.eTaVdUhgHijScENWEDcUitjKQlszP7 WfHOT7lhPvSxxGoyrJOqm7ZXSBQKP2Wti9.x7T9SokGXbzZ72KBWnGjyYXbZh6BFcb3PwkfU2dID Kk_K_4y19nEIyhcvDjE8QljIYSAv0MpWZ37SFCH0LInRqUtuyGv_CIdW8XRMnZxuzIHVYRDV4ouN 37jGDXRQTPEGj8367_i2mA3WCiHjBORDyTp589G85HKliJogNN.1QsuoYXdT_NwiKtTjNe1SlsVd _4SIzzi1q_fQ.h2bJlvI7AfDtucknxgjtvJZSwSumgcL32BzKN3R74a7y0.9kRPQjbO6HnZam8Po 3WOH78YlYiygFRWDay14cGM2_n5CoU7bySWQh33ClB_GbNw91YiupORgyxrbQTg2MqR92qv9zF8p _yX9yExAB.uOtA5SRSpep_coJ9H0IRVecKnzG_Kp23kGfnEn4zT_aZaMHx5aMLug8xPOJ4LYLZen NEX75OPNQBVV3XEgSe9PUiysgsXuVnjldR11TUpAzbBR_OrvJ6UVeHF2TZPLRnRcm6ZTP8ExWFm9 wGeqXUYbykdIfUrEVnlXkQu2A75rQEbX2wu91fmujnRWoU0RovFMG1c0Lyn0Fq31SxhfoGiusk7S mrfh_gZ8dz5lSGykxN8U.6X_8.q9IISqerr0RKCwn1N75f.m.vQ8G.tcD3AwVrFqVlcp.V1o08CZ zmbyxqoHxi0MwkZJdPvmzWgWxJx5O.v5Jx_by51V1tosMhXsusQOKx.XkerR_L_l7L28TGNk1zg_ ozdflx6aEgDLiZCCXbF7dpfl2DNkty1sYoQze3w2qmoI7aLmUh8hSNusUiBWz92mwWaG8zuCaCKJ yJbzQgF1S1b6zRca1u5SQsCTXAG72eMkUg9b6XqmZdOjvU.zXxo4- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Mon, 19 Jul 2021 22:48:42 +0000 Date: Mon, 19 Jul 2021 22:48:38 +0000 (UTC) From: Kevin Struckhoff To: "pgsql-admin@lists.postgresql.org" Message-ID: <1671906036.754266.1626734918424@mail.yahoo.com> Subject: Postgres 13.3 times out when attempting to connect via odbc & pgAdmin4 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_754265_765971563.1626734918422" References: <1671906036.754266.1626734918424.ref@mail.yahoo.com> X-Mailer: WebService/1.1.18469 YMailNorrin Content-Length: 7172 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_754265_765971563.1626734918422 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Just installed 13.3 on CentOS 8 runnning on a VM on my win 10 laptop. I am = getting an error while running the odbc connection=C2=A0 test:=20 could not connect to server: connection timed out.=20 This error occurs also with pAdmin4.5.5. on the CentOS server, I can see the correct ports listening: tcp=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0 0.0.0.0:5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 0.0.0.0:*=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 LISTEN=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1154/po= stmastertcp6=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 0 :::5432=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 :::*=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 LISTEN=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1154/postmaster I have listen_addresses set to '*' in postgresql.conf. The 1st entry below = didn't help: #listen_addresses =3D '192.168.56.101, localhost'=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 # what IP address(es) to listen on; listen_addresses =3D '*'=20 in the pg_hba.conf file I added the 3rd line below, since I've assigned a s= tatic IP address to the CentOS server: # IPv4 local connections: host=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 all=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 127.0.0.1/32=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 scram-sha-256 host =C2=A0=C2=A0 =C2=A0all =C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0all =C2= =A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0192.168.56.101/32=C2=A0=C2=A0 =C2=A0trus= t Changing the IP number to 192.168.56.1/24 didn't help either, as expected I= think. I have Postgres 12. running on another VM and I had no trouble connecting u= sing odbc and pgAdmin4. Not sure what may have changed between the 2 versions to bring out this err= or. The one thing I have noticed on 13.3 is that it now parses the listen_addre= sses =3D '192.168.56.101, localhost' string correctly. When I used this set= ting it opened port 5432 for both the static ip and 127.0.0.1. In 12.7, onl= y the port 1st ip number would be opened. With the static IP listed first, = postmaster wouldn't start automatically and if localhost was first, I could= n;t use odbc, etc. What am I missing here?=20 Thanks. Kevin ------=_Part_754265_765971563.1626734918422 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Just i= nstalled 13.3 on CentOS 8 runnning on a VM on my win 10 laptop. I am gettin= g an error while running the odbc connection  test:

could not connect to server: connection timed out.

This error occurs also with pAdmin4.5.5.

on the Cent= OS server, I can see the correct ports listening:

tcp        0    &= nbsp; 0 0.0.0.0:5432         &= nbsp;  0.0.0.0:*         =       LISTEN      1154/po= stmaster
tcp6  =      0      0 :::5432 &nb= sp;            =    :::*         &nbs= p;          LISTEN  =     1154/postmaster

I have listen_addresses set to '*' in postgresql.conf. The 1st entry be= low didn't help:
<= br>
#listen_address= es =3D '192.168.56.101, localhost'       = ;  # what IP address(es) to listen on;
listen_addresses =3D '*'

=
in the pg_hba.conf file= I added the 3rd line below, since I've assigned a static IP address to the= CentOS server:

# IPv4 local connections:
host&nb= sp;   all         &n= bsp;   all         &= nbsp;   127.0.0.1/32       &nb= sp;    scram-sha-256
host     all  &n= bsp;      all         192= .168.56.101/32    trust

Changing the IP number to 192.168.56.1/24 did= n't help either, as expected I think.

I = have Postgres 12. running on another VM and I had no trouble connecting usi= ng odbc and pgAdmin4.

Not sure what may have changed betw= een the 2 versions to bring out this error.

The one thing= I have noticed on 13.3 is that it now parses the listen_addresses = =3D '192.168.56.101, localhost' string correctly. When I used this setting = it opened port 5432 for both the static ip and 127.0.0.1. In 12.7, only the= port 1st ip number would be opened. With the static IP listed first, postm= aster wouldn't start automatically and if localhost was first, I couldn;t u= se odbc, etc.

=
What am I missing= here?

= Thanks. Kevin
------=_Part_754265_765971563.1626734918422--