On Mon, Dec 03, 2007 at 12:42:09PM +0000, Mika Stenberg wrote: > Im hoping to allow remote access to our postgres running with DSpace > 1.4.2. Im having problems with this though. Has anyone managed to > configure Postgres to accept incoming connections from other than > localhost as well? > > on postgres.conf I have added the following: > > listen_addresses = 'localhost, otto.terkko.helsinki.fi' > > and on pg_hba.conf i added host to listen : > > host all USERNAME md5 > > I also opened up the firewall for for 5432. Still I get a message: > > "Is the server running on host "tds.terkko.helsinki.fi" and accepting > TCP/IP connections on port 5432?" > > Any ideas, what could be causing this?
On the local machine (as root) try running either lsof -i tcp:5432 or telnet localhost 5432 If either of those shows that postgres is indeed listening on that port, try running the telnet command from the remote machine (something like telnet otto.terkko.helsinki.fi 5432). cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
