Re: [OT] revolver postgresql issue

[Johann Spies <jspies@sun.ac.za>]

On Tue, May 15, 2012 at 01:26:57PM +0200, J. Bakshi wrote:
> 
> I am using revolver solo version 8.4.6
> The system is working fine. I need to communicate the postgresql
> remotely, but the port 9977 which postgresql uses for revolver is bind
> to the localhost only.
> 
> At postgresql.conf there is already 
> 
> listen_addresses = '*'

This means: listen an all interfaces - not on localhost only.

> and at pg_hba.conf I have added the following 
> 
> host 	all 	    all 	   	   0.0.0.0/0		trust
> host 	all 	    all 	   	   192.168.0.1/24	password
> host 	all 	    revolverserver	   192.168.1.154	trust
> 
> The winxp box has firewall disabled. Still the port 9977 is not visible from any
> other PC of the same LAN. How can I open the port then for all ?

Where is the configuration to make Postgresql listen on port 9977?  That
is not a normal postgresql setup.  Normally it will listen on port 5432.

Regards
Johann
-- 
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

     "Let not your heart be troubled: ye believe in God, 
      believe also in me."       John 14:1 
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige lês aangeheg by hierdie e-pos nie.

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.