Have you checked your pg_hba.conf file and add the correct entry to allow the remote client ip address? Sorry don't have my file so I can't show you an example. But I think the docs and/or a google will show some examples.
Also you have to alter the postgresql.conf to allow tcp/ip connections. I think you can do this at the command line to. But maybe you have to do it in both the file and the command prompt?? Not sure as I'm on windows and it may be different then linux.
On 7/13/05, John Tulodziecki <johnt@squire-technologies.co.uk > wrote:Hi there
I am trying to run a simple client application on one linux box (running redhat 9) whilst the server (i.e postmaster) is running on another box.
I have successfully run the client program locally on the server machine.
I am getting connection refused when I try a remote connection
I have been through all the required settings in the conf files and I cannot see the error.
Can anyone please give me a simple example of a client program (please include required conf file settings)
which is communicating with a server program (please include required conf file settings) on another machine.
Am I right in saying that the postmaster process must only be running on the server machine ?
I have checked that the postmaster account is running on the server machine and is not running on the client
Machine.
Thank you.
John Tulodziecki
Senior Software Engineer
Squire Technologies Ltd
Phone +44(0)1305 757315
Web www.squire-technologies.com
Email johnt@squire-technologies.co.uk
NOTICE AND DISCLAIMER:
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of Squire Technologies Ltd. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents.