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