upgrade causes psql to not work

Поиск
Список
Период
Сортировка
От BJ Freeman
Тема upgrade causes psql to not work
Дата
Msg-id 50119D17.9030602@free-man.net
обсуждение исходный текст
Ответы Re: upgrade causes psql to not work  (Dave Cramer <pg@fastcrypt.com>)
Re: upgrade causes psql to not work  (BJ Freeman <bjfree@free-man.net>)
Список pgsql-jdbc
did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
console:
[root@main jdbc]# psql -h localhost -U gameserver
passwordfromentityengine.xml

psql: could not connect to server: Connection refused
         Is the server running on host "localhost" and accepting
         TCP/IP connections on port 5432?

I notice there is no localhost and th 127.0.0.1 has /32 added.
I can not add a localhost to the allowed hosts

psql is running
if I do
[root@main jdbc]# psql  -U gameserver
  passwordfromentityengine.xml
with out defining the host, it works.

I believe it is using Unix pipes instead of TCP
I also can manage the psql server through webmin.

I looked on the http://jdbc.postgresql.org/
and could not find any docs on the jdbc string to use my old one with
localhost and 127.0.0.1 do not work any more.
here is the conf
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 0.0.0.0 0.0.0.0 trust


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Radim Kolar
Дата:
Сообщение: Re: not fetching all query results
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: upgrade causes psql to not work