Thread: upgrade causes psql to not work
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
Check in postgresql.conf to make sure it is listening on the tcpip port listen_address='... netstat -nlp | grep 5432 will tell you for sure Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Thu, Jul 26, 2012 at 3:40 PM, BJ Freeman <bjfree@free-man.net> wrote: > 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 > > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
Dave
sorry was not subscribe before i sent this, I am now
> netstat -nlp | grep 5432
tcp 0 0 69.94.133.32:5432 0.0.0.0:* LISTEN
2699/postmaster
unix 2 [ ACC ] STREAM LISTENING 9964 2699/postmaster
/tmp/.s.PGSQL.5432
BJ Freeman sent the following on 7/26/2012 12:40 PM:
> 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
>
OK, so there is your problem. It is only listening on 69.94.133.32 I usually set listen_address = '*' Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Thu, Jul 26, 2012 at 4:02 PM, BJ Freeman <bjfree@free-man.net> wrote: > Dave > sorry was not subscribe before i sent this, I am now > >> netstat -nlp | grep 5432 > tcp 0 0 69.94.133.32:5432 0.0.0.0:* LISTEN > 2699/postmaster > > unix 2 [ ACC ] STREAM LISTENING 9964 2699/postmaster > /tmp/.s.PGSQL.5432 > > > BJ Freeman sent the following on 7/26/2012 12:40 PM: > >> 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 >> > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc