public inbox for [email protected]
help / color / mirror / Atom feedFrom: [email protected] <[email protected]>
To: 'Konstantin Knizhnik' <[email protected]>
Cc: Jaime Casanova <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: Ryan Lambert <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Dimitri Fontaine <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Subject: RE: Built-in connection pooler
Date: Thu, 14 Nov 2019 01:17:19 +0000
Message-ID: <OSAPR01MB1985554A600901FF0B8D125FEA710@OSAPR01MB1985.jpnprd01.prod.outlook.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<OSAPR01MB1985068ABB08A85828999460EA770@OSAPR01MB1985.jpnprd01.prod.outlook.com>
<[email protected]>
Hi
>From: Konstantin Knizhnik [mailto:[email protected]]
>>> From: Konstantin Knizhnik [mailto:[email protected]]
>>>
>>> New version of builtin connection pooler fixing handling messages of
>>> extended protocol.
>>>
>> 2. When proxy_port is a bit large (perhaps more than 2^15), connection
>> failed though regular "port" is fine with number more than 2^15.
>>
>> $ bin/psql -p 32768
>> 2019-11-12 16:11:25.460 JST [5617] LOG: Message size 84
>> 2019-11-12 16:11:25.461 JST [5617] WARNING: could not setup local
>> connect to server
>> 2019-11-12 16:11:25.461 JST [5617] DETAIL: invalid port number: "-22768"
>> 2019-11-12 16:11:25.461 JST [5617] LOG: Handshake response will be
>> sent to the client later when backed is assigned
>> psql: error: could not connect to server: invalid port number: "-22768"
>Hmmm, ProxyPortNumber is used exactly in the same way as PostPortNumber.
>I was able to connect to the specified port:
>
>
>knizhnik@knizhnik:~/dtm-data$ psql postgres -p 42768 psql (13devel) Type "help" for
>help.
>
>postgres=# \q
>knizhnik@knizhnik:~/dtm-data$ psql postgres -h 127.0.0.1 -p 42768 psql (13devel)
>Type "help" for help.
>
>postgres=# \q
For now I replay for the above. Oh sorry, I was wrong about the condition.
The error occurred under following condition.
- port = 32768
- proxy_port = 6543
- $ psql postgres -p 6543
$ bin/pg_ctl start -D data
waiting for server to start....
LOG: starting PostgreSQL 13devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
LOG: listening on IPv6 address "::1", port 6543
LOG: listening on IPv4 address "127.0.0.1", port 6543
LOG: listening on IPv6 address "::1", port 32768
LOG: listening on IPv4 address "127.0.0.1", port 32768
LOG: listening on Unix socket "/tmp/.s.PGSQL.6543"
LOG: listening on Unix socket "/tmp/.s.PGSQL.32768"
LOG: Start proxy process 25374
LOG: Start proxy process 25375
LOG: database system was shut down at 2019-11-12 16:49:20 JST
LOG: database system is ready to accept connections
server started
[postgres@vm-7kfq-coreban connection-pooling]$ psql -p 6543
LOG: Message size 84
WARNING: could not setup local connect to server
DETAIL: invalid port number: "-32768"
LOG: Handshake response will be sent to the client later when backed is assigned
psql: error: could not connect to server: invalid port number: "-32768"
By the way, the patch has some small conflicts against master.
Regards,
Takeshi Ideriha
view thread (72+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: RE: Built-in connection pooler
In-Reply-To: <OSAPR01MB1985554A600901FF0B8D125FEA710@OSAPR01MB1985.jpnprd01.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox