Migrating from 8.2 to 9.1 : invalid port number

From: Alberto Zanon <alberto(dot)zanon(at)edistar(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Migrating from 8.2 to 9.1 : invalid port number
Date: 2012-05-23 12:56:26
Message-ID: 1281928390.73514.1337777785970.JavaMail.root@mailserver.edistar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 behavior?
I noticed that it accepts values up to 65535 .

Thanks in advance

Alberto

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 2012-05-23 13:11:06 Up-to-date reports database
Previous Message Andy Colson 2012-05-23 02:19:46 Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1