pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 16 timed out
3+ messages / 3 participants
[nested] [flat]
* PostgreSQL 16 timed out
@ 2024-04-21 05:54 Сергеев Аркадий <asoft65@mail.ru>
0 siblings, 1 reply; 3+ messages in thread
From: Сергеев Аркадий @ 2024-04-21 05:54 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi, I have some troubles with PostgreSQL 16.
My current state:
- Windows 11
- PostgreSQL 15 installed and working
- PostgreSQL installed, but don’t allow me connect via PgAdmin4
In services I see postgresql-x64-16 — running installen on port 5434
service postgresql-x64-15 - PostgreSQL Server 15 also running
I’he try to stop postgresql-x64-15 and login in PgAdmin to PostgreSQL 16, but recive the same error — timed out
Is it possible to have both PostreSQL on one machine? What is my mistake.
I don’t want to uninstall PostrgeSQL 15, but I wat to try PostgeSQL16 may be it resolve my problem:
when I write proghram on Python and work with PostgreSQL via SQLAlchemy, now I get the error
OSError: [WinError 64] Указанное сетевое имя более недоступно
During handling of the above exception, another exception occurred:
…
asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation
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’ve tested yet — no result.
--
С уважением,
Сергеев Аркадий
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL 16 timed out
@ 2024-04-22 09:13 Holger Jakobs <holger@jakobs.com>
parent: Сергеев Аркадий <asoft65@mail.ru>
0 siblings, 1 reply; 3+ messages in thread
From: Holger Jakobs @ 2024-04-22 09:13 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 21.04.24 um 07:54 schrieb Сергеев Аркадий:
> Hi, I have some troubles with PostgreSQL 16.
> My current state:
> - Windows 11
> - PostgreSQL 15 installed and working
> - PostgreSQL installed, but don’t allow me connect via PgAdmin4
> In services I see postgresql-x64-16 — running installen on port 5434
> service postgresql-x64-15 - PostgreSQL Server 15 also running
> I’he try to stop postgresql-x64-15 and login in PgAdmin to PostgreSQL
> 16, but recive the same error — timed out
> Is it possible to have both PostreSQL on one machine? What is my mistake.
> I don’t want to uninstall PostrgeSQL 15, but I wat to try
> PostgeSQL16 may be it resolve my problem:
> when I write proghram on Python and work with PostgreSQL via
> SQLAlchemy, now I get the error
> OSError: [WinError 64] Указанное сетевое имя более недоступно
> During handling of the above exception, another exception occurred:
> …
> asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed
> in the middle of operation
> 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’ve
> tested yet — no result.
> --
> С уважением,
> Сергеев Аркадий
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
chat with me on Signal messenger
<https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LUeBOphfXFFgLYYVXv_AGhg;
Attachments:
[image/png] ZF0WM8A8ppZjFe31.png (551B, ../../394df40f-e1c5-6307-3f11-b1c3eff64eda@jakobs.com/3-ZF0WM8A8ppZjFe31.png)
download | view image
[application/pgp-signature] OpenPGP_signature (202B, ../../394df40f-e1c5-6307-3f11-b1c3eff64eda@jakobs.com/4-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL 16 timed out
@ 2024-04-22 14:43 Zaid Shabbir <zaidshabbir@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 3+ messages in thread
From: Zaid Shabbir @ 2024-04-22 14:43 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
Hello Holger,
Comments inline...
On Mon, Apr 22, 2024 at 2:13 PM Holger Jakobs <holger@jakobs.com> wrote:
> Am 21.04.24 um 07:54 schrieb Сергеев Аркадий:
>
> Hi, I have some troubles with PostgreSQL 16.
> My current state:
> - Windows 11
> - PostgreSQL 15 installed and working
> - PostgreSQL installed, but don’t allow me connect via PgAdmin4
>
> In services I see postgresql-x64-16 — running installen on port 5434
> service postgresql-x64-15 - PostgreSQL Server 15 also running
>
> I’he try to stop postgresql-x64-15 and login in PgAdmin to PostgreSQL 16,
> but recive the same error — timed out
>
> Is it possible to have both PostreSQL on one machine? What is my mistake.
>
> Side by side installation of PostgreSQL supported. I hope you are using
the official PostgresSQL latest installers shared on
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
I don’t want to uninstall PostrgeSQL 15, but I wat to try PostgeSQL16 may
> be it resolve my problem:
> when I write proghram on Python and work with PostgreSQL via SQLAlchemy,
> now I get the error
>
> OSError: [WinError 64] Указанное сетевое имя более недоступно
> During handling of the above exception, another exception occurred:
> …
> asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in
> the middle of operation
>
> 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’ve tested
> yet — no result.
>
> --
> С уважением,
> Сергеев Аркадий
>
>
> 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
>
> chat with me on Signal messenger
> <https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LUeBOphfXFFgLYYVXv_AGhg;
>
Attachments:
[image/png] ZF0WM8A8ppZjFe31.png (551B, ../../CABCJe_XCExS47Ay_BshL_BXB4z2Gu1zx7Q5rQGrro-K5GY6xyw@mail.gmail.com/3-ZF0WM8A8ppZjFe31.png)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-04-22 14:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-21 05:54 PostgreSQL 16 timed out Сергеев Аркадий <asoft65@mail.ru>
2024-04-22 09:13 ` Holger Jakobs <holger@jakobs.com>
2024-04-22 14:43 ` Zaid Shabbir <zaidshabbir@gmail.com>
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