port numbers are restricted to 2 octets (16 bits). they are TCP/IP entities and are restricted in size by the RFCs (internet standards.)
From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Alberto Zanon
Sent: Wed 5/23/2012 10:19 AM
To: Merlin Moncure
Subject: Re: Migrating from 8.2 to 9.1 : invalid port number
Thanks Merlin for the reply,
when you define a " Unix domain socket " you can use any number because it's just used for the filename, e.g. "/var/run/.s.PGSQL.123456".
It works in PgPool and Postgres 8.2 with no problems.
----- Messaggio originale -----
Da: "Merlin Moncure" <mmoncure@xxxxxxxxx>
A: "Alberto Zanon" <alberto.zanon@xxxxxxxxxxx>
Inviato: Mercoledì, 23 maggio 2012 15:45:26
Oggetto: Re: Migrating from 8.2 to 9.1 : invalid port number
On Wed, May 23, 2012 at 7:56 AM, Alberto Zanon
> Hi all,
> in my production environment I have Postgresql 8.2 + PgPool. The port number
> I specify in PgPool configuration is not a real portnumber (e.g. 123456). I
> can define a "dblink" as :
> dblink('dbname=XXXX host=/var/run port=123456 user=XXXX
> password=XXXX'::text, 'select ... '::text) t1( ... );
> or start "psql" as:
> psql -U XXXX -h /var/run -p 123456 XXXX
> without problems. In my development environment I upgraded to 9.1 version
> and the result is:
> invalid port number: "123456"
> in both cases. Does Postgresql 9.1 check the "port number" value although
> I'm connecting through a "Unix domain socket"? Is it a bug or an intended
> I noticed that it accepts values up to 65535.
65535 is the highest port number so what's happening here is 9.1 is
just doing error checking on the input value which is totally normal
and expected. why are you supplying a bogus port number?
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]