Unable to Connect to SOAPware Server
There are two settings in PostgreSQL's configuration files that can affect SOAPware running on client computers. If you are not able to run SOAPware on your clients and connect to the server, it is possible that you need to make the proper changes in your PostgreSQL configuration files located on the server.
There are two places to look to make sure PostgreSQL is configured to allow connections from client computers. On your server computer, perform the following steps:
1. Check the pg_hba config file
1. Click on Start, then All Programs, PostgreSQL 8.x,Configuration Files and Edit pg_hba.conf.
2. Scroll to the bottom of the file. You should see two lines under # IPv4 local connections that appears as shown in the image above. Note: If you do not see the second line, type it in just like it is displayed in the image above.
3. Click on File > Save. You can close the file now.
2. Check the pstgresql config file
1. Click on Start, All Programs, PostgreSQL 8.x, Configuration Files and Edit postgresql.conf.
2. Scroll down just a little bit until you see the information as shown in the image above. Make sure the listen_addresses line appears exactly as shown in the image. If it has a pound sign (#) in front of it, remove the pound sign. If an asterisk (*) is not in between the two single quotes on the right side, change it to an asterisk.
3. Click on File > Save. You can close the file now.
3. Restart the PostgreSQL Database Server (if changes were made)
If you made changes to either file, then you must restart the PostgreSQL Database Server to force the changes into effect.
1. Click on Start > All Programs > PostgreSQL 8.x > Stop Service
2. After the previous window closes, click on Start > All Programs > PostgreSQL 8.x > Start Service
Run SOAPware
After making the above changes, try running SOAPware on your clients.
If SOAPware still doesn't connect or these configuration files were already correct when you checked them, it is possible that a firewall could be preventing a successful connection. A firewall on your server or any of your client computers can prevent a connection, so make sure and check each computer. For SOAPware to function, it needs to communicate over port 5432. Make sure this port is open in your firewall settings.