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
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 |