Re: [OT] revolver postgresql issue



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.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx
Archive: http://lists.debian.org/20120515120250.GC32502@xxxxxxxxx