Client-Server Example
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 <http://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.
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.
Show quoted text
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 clientMachine.
Thank you.
John Tulodziecki
Senior Software Engineer
Squire Technologies LtdPhone +44(0)1305 757315
Web www.squire-technologies.com <http://www.squire-technologies.com/>
Email johnt@squire-technologies.co.ukNOTICE 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.