Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rypjw-000icc-ID for pgsql-admin@arkaria.postgresql.org; Mon, 22 Apr 2024 09:13:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rypju-000yYV-Nm for pgsql-admin@arkaria.postgresql.org; Mon, 22 Apr 2024 09:13:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rypju-000yYK-BX for pgsql-admin@lists.postgresql.org; Mon, 22 Apr 2024 09:13:30 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rypjr-002JKG-F0 for pgsql-admin@lists.postgresql.org; Mon, 22 Apr 2024 09:13:29 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 9A3CE3807C8; Mon, 22 Apr 2024 11:13:23 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id LLQvZwEYekuh; Mon, 22 Apr 2024 11:13:19 +0200 (CEST) Received: from [192.168.178.86] (xdsl-87-78-248-241.nc.de [87.78.248.241]) by rs.plausibolo.de (Postfix) with ESMTPSA id 974B43801CD; Mon, 22 Apr 2024 11:13:17 +0200 (CEST) Message-ID: <394df40f-e1c5-6307-3f11-b1c3eff64eda@jakobs.com> Date: Mon, 22 Apr 2024 11:13:16 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <1713678846.649965047@f112.i.mail.ru> From: Holger Jakobs Subject: Re: PostgreSQL 16 timed out In-Reply-To: <1713678846.649965047@f112.i.mail.ru> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------pv787u3BWzy1P9osgt1uHErg" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------pv787u3BWzy1P9osgt1uHErg Content-Type: multipart/mixed; boundary="------------2XlUuWaREVIacDrd04xEGSZ5"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <394df40f-e1c5-6307-3f11-b1c3eff64eda@jakobs.com> Subject: Re: PostgreSQL 16 timed out References: <1713678846.649965047@f112.i.mail.ru> In-Reply-To: <1713678846.649965047@f112.i.mail.ru> --------------2XlUuWaREVIacDrd04xEGSZ5 Content-Type: multipart/alternative; boundary="------------1QMTq6XhfJ9e0N0zNSWNLM2o" --------------1QMTq6XhfJ9e0N0zNSWNLM2o Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMjEuMDQuMjQgdW0gMDc6NTQgc2NocmllYiDQodC10YDQs9C10LXQsiDQkNGA0LrQsNC0 0LjQuToNCj4gSGksIEkgaGF2ZSBzb21lIHRyb3VibGVzIHdpdGggUG9zdGdyZVNRTCAxNi4N Cj4gTXkgY3VycmVudCBzdGF0ZToNCj4gLSBXaW5kb3dzIDExDQo+IC0gUG9zdGdyZVNRTCAx NSBpbnN0YWxsZWQgYW5kIHdvcmtpbmcNCj4gLSBQb3N0Z3JlU1FMIGluc3RhbGxlZCwgYnV0 IGRvbuKAmXQgYWxsb3cgbWUgY29ubmVjdCB2aWEgUGdBZG1pbjQNCj4gSW4gc2VydmljZXMg SSBzZWXCoHBvc3RncmVzcWwteDY0LTE2IOKAlMKgcnVubmluZyBpbnN0YWxsZW4gb24gcG9y dCA1NDM0DQo+IHNlcnZpY2XCoHBvc3RncmVzcWwteDY0LTE1IC0gUG9zdGdyZVNRTCBTZXJ2 ZXIgMTUgYWxzbyBydW5uaW5nDQo+IEnigJloZSB0cnkgdG8gc3RvcMKgcG9zdGdyZXNxbC14 NjQtMTUgYW5kIGxvZ2luIGluIFBnQWRtaW4gdG8gUG9zdGdyZVNRTCANCj4gMTYsIGJ1dCBy ZWNpdmUgdGhlIHNhbWUgZXJyb3Ig4oCUwqB0aW1lZCBvdXQNCj4gSXMgaXQgcG9zc2libGUg dG8gaGF2ZSBib3RoIFBvc3RyZVNRTCBvbiBvbmUgbWFjaGluZT8gV2hhdCBpcyBteSBtaXN0 YWtlLg0KPiBJIGRvbuKAmXQgd2FudCB0byB1bmluc3RhbGwgUG9zdHJnZVNRTCAxNSwgYnV0 IEkgd2F0IHRvIHRyeSANCj4gUG9zdGdlU1FMMTbCoG1heSBiZSBpdCByZXNvbHZlIG15IHBy b2JsZW06DQo+IHdoZW4gSSB3cml0ZSBwcm9naHJhbSBvbiBQeXRob24gYW5kIHdvcmsgd2l0 aCBQb3N0Z3JlU1FMIHZpYSANCj4gU1FMQWxjaGVteSwgbm93IEkgZ2V0IHRoZSBlcnJvcg0K PiBPU0Vycm9yOiBbV2luRXJyb3IgNjRdINCj0LrQsNC30LDQvdC90L7QtSDRgdC10YLQtdCy 0L7QtSDQuNC80Y8g0LHQvtC70LXQtSDQvdC10LTQvtGB0YLRg9C/0L3Qvg0KPiBEdXJpbmcg aGFuZGxpbmcgb2YgdGhlIGFib3ZlIGV4Y2VwdGlvbiwgYW5vdGhlciBleGNlcHRpb24gb2Nj dXJyZWQ6DQo+IOKApg0KPiBhc3luY3BnLmV4Y2VwdGlvbnMuQ29ubmVjdGlvbkRvZXNOb3RF eGlzdEVycm9yOiBjb25uZWN0aW9uIHdhcyBjbG9zZWQgDQo+IGluIHRoZSBtaWRkbGUgb2Yg b3BlcmF0aW9uDQo+IFRoaXMgZXJyb3IgcmFpc2VkIHdoZW4gSSB0cnkgQ1JFQVRFIFRBQkxF IGFuZCBldmVuIHdoZW4gSSB0cnkgU0VMRUNUIA0KPiBzdGF0ZW1lbnQNCj4gSSBkb24ndCBr bm93IHdoZXJlIHRoZSBlcnJvciBpcywgaW4gU1FMQWxjaGVteSBvciBpbiBhc3luY3BnIG9y IGluIA0KPiBQb3N0cmdlU1FMIG9yIGluIG15IGNvZGUuIE15IGNvZGUgZnVsbHkgdGhlIHNh bWUgYXMgaW4gdmlkZW8gd2hlcmUgYWxsIA0KPiB3b3JraW5nIHByb3Blcmx5LiBTbyBJIHdh bnQgdG8gdGVzdCBQb3N0Z3JlU1FMIDE2LCBQeXRob24gMy4xMSBJ4oCZdmUgDQo+IHRlc3Rl ZCB5ZXQg4oCUwqBubyByZXN1bHQuDQo+IC0tDQo+INChINGD0LLQsNC20LXQvdC40LXQvCwN Cj4g0KHQtdGA0LPQtdC10LIg0JDRgNC60LDQtNC40LkNCg0KSGF2aW5nIHNldmVyYWwgY2x1 c3RlcnMgKGluc3RhbGxhdGlvbnMpIG9mIFBvc3RncmVTUUwgb24gdGhlIHNhbWUgDQptYWNo aW5lIG5lZWQgZGlmZmVyZW50IHBvcnQgbnVtYmVycy4gVGhlIGRlZmF1bHQgaXN0IDU0MzIs IHVzdWFsbHkgDQpmdXJ0aGVyIGluc3RhbGxhdGlvbnMgdXNlIDU0MzMsIDU0MzQgYW5kIHNv IG9uLg0KDQpJZiB5b3Ugd2FudCB0byB0ZXN0IHRoZSBjb25uZWN0aXZpdHkgb2YgeW91ciBz ZXJ2ZXIsIGl0J3MgYmVzdCAqbm90KiB0byANCnVzZSBhbnkgdGhpcmQgcGFydHkgdG9vbHMg KHBnQWRtaW4gaXMgb25lIG9mIHRoZW0pLCBidXQgcHNxbCwgd2hpY2ggaXMgDQpwYXJ0IG9m IHRoZSBQb3N0Z3JlU1FMIHNvZnR3YXJlLiBJdCB0ZW5kcyB0byBnaXZlIGJldHRlciBlcnJv ciBtZXNzYWdlcy4gDQpBbmQgb2YgY291cnNlLCBoYXZlIGEgbG9vayBhdCB0aGUgbG9nIGZp bGVzLg0KDQpSZWdhcmRzLA0KSG9sZ2VyDQoNCg0KLS0gDQoNCkhvbGdlciBKYWtvYnMsIEJl cmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQpjaGF0IHdpdGggbWUg b24gU2lnbmFsIG1lc3NlbmdlciANCjxodHRwczovL3NpZ25hbC5tZS8jZXUvR3BJUDI1OWJC bmVfSmlCWUpGdmJaQ0xZSkVMaEItOTJuSmZuY0FDTDFMVWVCT3BoZlhGRmdMWVlWWHZfQUdo Zz4NCg0K --------------1QMTq6XhfJ9e0N0zNSWNLM2o Content-Type: multipart/related; boundary="------------tFjImPRU8imTS7rutpdpr1w7" --------------tFjImPRU8imTS7rutpdpr1w7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Am 21.04.24 um 07:54 schrieb =D0=A1=D0= =B5=D1=80=D0=B3=D0=B5=D0=B5=D0=B2 =D0=90=D1=80=D0=BA=D0=B0=D0=B4=D0=B8=D0=B9:
Hi, I have some troubles with PostgreSQL 16.
My current state:
- Windows 11
- PostgreSQL 15 installed and working
- PostgreSQL installed, but don=E2=80=99t allow me connect via= PgAdmin4
=C2=A0
In services I see=C2=A0postgresql-x64-16 =E2=80=94=C2=A0runnin= g installen on port 5434
service=C2=A0postgresql-x64-15 - PostgreSQL Server 15 also run= ning
=C2=A0
I=E2=80=99he try to stop=C2=A0postgresql-x64-15 and login in P= gAdmin to PostgreSQL 16, but recive the same error =E2=80=94=C2=A0timed out=
=C2=A0
Is it possible to have both PostreSQL on one machine? What is my mistake.
I don=E2=80=99t want to uninstall PostrgeSQL 15, but I wat to = try PostgeSQL16=C2=A0may be it resolve my problem:
when I write proghram on Python and work with PostgreSQL via SQLAlchemy, now I get the error
=C2=A0
OSError: [WinError 64] =D0=A3=D0=BA=D0=B0=D0=B7=D0=B0=D0=BD=D0= =BD=D0=BE=D0=B5 =D1=81=D0=B5=D1=82=D0=B5=D0=B2=D0=BE=D0=B5 =D0=B8=D0=BC=D1= =8F =D0=B1=D0=BE=D0=BB=D0=B5=D0=B5 =D0=BD=D0=B5=D0=B4=D0=BE=D1=81=D1=82=D1= =83=D0=BF=D0=BD=D0=BE
During handling of the above exception, another exception occurred:
=E2=80=A6
asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
=C2=A0
This error raised when I try CREATE TABLE and even when I try SELECT statement
I don't know where the error is, in SQLAlchemy or in asyncpg or in PostrgeSQL or in my code. My code fully the same as in video where all working properly. So I want to test PostgreSQL 16, Python 3.11 I=E2=80=99ve tested yet =E2=80=94=C2=A0no result.=
=C2=A0
--
=D0=A1 =D1=83=D0=B2=D0=B0=D0=B6=D0=B5=D0=BD=D0=B8=D0=B5=D0=BC= ,
=D0=A1=D0=B5=D1=80=D0=B3=D0=B5=D0=B5=D0=B2 =D0=90=D1=80=D0=BA= =D0=B0=D0=B4=D0=B8=D0=B9

Having several clusters (installations) of PostgreSQL on the same machine need different port numbers. The default ist 5432, usually further installations use 5433, 5434 and so on.

If you want to test the connectivity of your server, it's best *not* to use any third party tools (pgAdmin is one of them), but psql, which is part of the PostgreSQL software. It tends to give better error messages. And of course, have a look at the log files.

Regards,
Holger


--

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
3D""
chat with me on Signal messenger

--------------tFjImPRU8imTS7rutpdpr1w7 Content-Type: image/png; name="ZF0WM8A8ppZjFe31.png" Content-Disposition: inline; filename="ZF0WM8A8ppZjFe31.png" Content-Id: Content-Transfer-Encoding: base64 iVBORw0KGgoAAAANSUhEUgAAAIcAAACHAQMAAAAGKdhJAAAABlBMVEUAAAD///+l2Z/dAAAA AnRSTlP//8i138cAAAAJcEhZcwAACxIAAAsSAdLdfvwAAAG5SURBVEiJ3da7bcMwEAbgM1iw kxYQwDXYcSVpAT0WkFdixzUIcAGqY0Hw8suJHSCNzkCKIIKg4isI3tMm/vnQP5FMtIQ4lbr4 SmSEcnCdHa/W7FQXFosfcEjvK76jfkNmp+6Bm35XqNOxs+8II8ahsxEXeEVxKcjPFIbP95Wx S8FzFN5dJP1dnUvJmm5sVocviiIV5pStyna4FcRrhJItTQUpqrMeehaLVk3TaIlcHZ1Umq2o wsQ0OvrMqkQOhEn1Fs5I+yCVRnEJidHSIZKVChdeiXer2nkTFko7a2cOTluJX1EIJGtzLwqz s7q6BKngnNtjEJp+RiGQrNN61kLt1qDZhMIlzrb2xdwx5l/5uZaMWmOHWLOFODupsI/kUnao hWpWKkdJ94L+xM2xTFgojQY0f3Np47gUIxT2iYvKp6RdS+Xw1PthdI9ZIKk0m45AHSHM550F chSaPGqhDsYgSAVPxuwU9BjqboRy7jpO6OfshtFKBXt1tKh+ajiHxXImxzCrHeuuvCEzqc2r VfP22JBCwa7DT+GIIj7PuRY+V1ZHmAU0AAvlzA9qwQYLeXpl9Up+61/B35IPLEvZkYbCln8A AAAASUVORK5CYII= --------------tFjImPRU8imTS7rutpdpr1w7-- --------------1QMTq6XhfJ9e0N0zNSWNLM2o-- --------------2XlUuWaREVIacDrd04xEGSZ5-- --------------pv787u3BWzy1P9osgt1uHErg Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZiYqLAUDAAAAAAAKCRCKV5yTsxlhuiTq AJ4tYigx08lXYi+pvJTRuYPvSp0quwCgsncEd5z8zVWGBinrPhX4nF2s26g= =o/+r -----END PGP SIGNATURE----- --------------pv787u3BWzy1P9osgt1uHErg--