Re: [ADMIN] Database port changing issue

2006-06-09 Thread louis gonzales
I'm sorry but this is wrong, localhost IS 127.0.0.1 and IS a fundamental component of TCP/IP. UNIX Domain sockets - known to most as file descriptors - are entirely different! localhost != UNIX Domain sockets! I wish people would read up on this to stop perpetuating the misunderstanding of '

Re: [ADMIN] Database port changing issue

2006-06-09 Thread louis gonzales
Hello Chris, While yes, IF one were in a relative 'external' position - such as the Internet - attempting to connect to this database that was internal - assuming there was a firewall separating the two systems, one could possibly assume there is a firewall filter, preventing this connectivity

Re: [ADMIN] Database port changing issue

2006-06-09 Thread Chris Browne
[EMAIL PROTECTED] ("Guido Barosio") writes: > That's because your listen_addresses parameter points to localhost, > and that means that your will listen for connections through unix > sockets instead of via TCP/IP. > > In order to change this, you'll need to replace the string localhost > with the

Re: [ADMIN] Database port changing issue

2006-06-09 Thread Chris Hoover
sounds like you might have a firewall blocking the new port.  Make sure you can connect locally the the database, and then get a hole poked in your iptables firewall (assuming this is a linux server)HTH,Chris On 6/9/06, Mohamed Fazil <[EMAIL PROTECTED]> wrote: Hi to all,   I am facing an issue wh

Re: [ADMIN] Database port changing issue

2006-06-09 Thread Guido Barosio
s/that your will listen /your server will listen/ eof :x On 6/9/06, Guido Barosio <[EMAIL PROTECTED]> wrote: That's because your listen_addresses parameter points to localhost, and that means that your will listen for connections through unix sockets instead of via TCP/IP. In order to change t

Re: [ADMIN] Database port changing issue

2006-06-09 Thread Guido Barosio
That's because your listen_addresses parameter points to localhost, and that means that your will listen for connections through unix sockets instead of via TCP/IP. In order to change this, you'll need to replace the string localhost with the proper value. (A bad habit, to replace the 'localhost'

Re: [ADMIN] Database port changing issue

2006-06-09 Thread Adam Witney
> But i am getting an error as mentioned below > > *org.postgresql.util.PSQLException: Connection refused. Check that the > hostname and port are correct and that the postmaster is accepting > TCP/IP connections.* > ** > What are the changes that i have to do for changing port. > > If i am r