Re: [GENERAL] Connection Refused Error

2009-03-09 Thread Joshua D. Drake
On Mon, 2009-03-09 at 19:09 -0500, JohnD wrote: > Joshua D. Drake wrote: > > What does your listen_addresses say on the affected server? Also just to > > be safe do a /sbin/iptables -L and make sure you aren't blocking. > > > > Joshua, > > Thank you so much - that was it. My postgresql.conf l

Re: [GENERAL] Connection Refused Error

2009-03-09 Thread JohnD
Joshua D. Drake wrote: What does your listen_addresses say on the affected server? Also just to be safe do a /sbin/iptables -L and make sure you aren't blocking. Joshua, Thank you so much - that was it. My postgresql.conf listen_addresses was commented out which defaulted to 'localhost'.

Re: [GENERAL] Connection Refused Error

2009-03-09 Thread Joshua D. Drake
On Mon, 2009-03-09 at 18:11 -0500, JohnD wrote: > Hi, > Any idea why I am no longer able to connect? > What does your listen_addresses say on the affected server? Also just to be safe do a /sbin/iptables -L and make sure you aren't blocking. Joshua D. Drake > Thanks for any and all help. > >

Re: [GENERAL] Connection Refused Error

2009-03-09 Thread Adrian Klaver
On Monday 09 March 2009 4:11:49 pm JohnD wrote: > Hi, > > I have two "identical" servers running CentOS 5.2 with PostgreSQL 8.3.5 > installed on both. Prior to a reboot this morning, I was able to > connect, remotely, to both of them and doing telnet 5432 > brought up a prompt for them as well. >

Re: [GENERAL] Connection Refused Error

2009-03-09 Thread Tom Lane
JohnD writes: > I can ssh into the server and do a psql from the > /var/lib/pgsql command prompt, as user postgres. But, when I try to use > a different user (psql -U user -p ), from the same prompt, I get: > psql: could not connect to server: No such file or directory > Is the server run

[GENERAL] Connection Refused Error

2009-03-09 Thread JohnD
Hi, I have two "identical" servers running CentOS 5.2 with PostgreSQL 8.3.5 installed on both. Prior to a reboot this morning, I was able to connect, remotely, to both of them and doing telnet 5432 brought up a prompt for them as well. However, I am now in the unfortunate situation of not