PostGre SQL

English mAirList 5.x
1

I have set up PostgreSQL database, managed to create network databse on the host PC, however when i try to access the database from abnother PC i can’t. It seems the libpq74.dll is missing. I cant locate it anywhere. The manual for 3.0 refers to PostgreSQL client library but I have no idea where that file is.

In my mairlist set up folder i have a libpg.dll file. Do i need to copy that file on the remote machine? And lastly, do I need to install PostgreSQL on the other machines I want to access the database from or not?

2

Older mAirList versions until 4.3 use libpq74.dll, newer versions since 4.4 use libpq.dll. It’s the same file, just with a different name (to match the requirements of the SQL library I’m using, which has changed in v4.4).

The file is shipped with mAirList, you will find it in the program folder. It’s not necessary to copy it around manually.

What’s the exact error message on the second PC?

3

Torben, attached is the screen shot. The firewall is turned off and I cant think of anything else…

error.png

4

A fresh installation of PostgreSQL won’t accept any network connections, only from the local host. You must edit postgresql.conf and set

listen_addresses = *

And also make a proper pg_hba.conf entry for your network, see e.g. here (Step 4):

http://www.mairlist.com/en/blog/using-a-synology-nas-as-postgresql-server-for-mairlistdb/

(That article is about PosgreSQL on a Synology NAS; the *.conf files can be found in the PostgreSQL data directory if it’s running on Windows.)

Don’t forget to restart the PostgreSQL service.

Another tip: You can copy the text of these error dialogs with Ctrl+C as text - no need for a screenshot.

5

Hi,

The postgre SQL config file has this line: listen_address=(*) I assume the parentheses are not a problem8.

I am also attaching the screen shot of the config file. It looks ok to be as my network is in the range od 192.168.1.90/100. The postgreSQL is hosted on 192.168.1.94

database.png

6

Looking at the message again - “timeout” hints at a firewall issue, something preventing the TCP packets from going through.

Are you sure that you opened the ports on both the server and client machine? The server must be accessible on TCP port 5432. On the client machine, the mAirList application must be granted access to the network.

7

Both are open and accessible. Is it maybe the fact that I am networked via wi-fi rather than LAN?

8

Well, if you are getting timeouts, the port is definitely blocked by some sort of firewall. (Or you mistyped the IP address.) If the port was reachable, you would either get a connection, or at least a “connection refused” error (if the port is open but no application is listening).

9

I by-passed the port blocking issue and BANG… i get this. I tried removing the old database and restarting the system but the message still s hows. When I test the connection I get Login OK.

database error new.png

10

After the message, I went and clicked configure database anyway. I managed to set up some categories on one of the PC’s. Then I had to restart both due to windows update. After the re-boot neither can connect to the database. They both give me the same error message. What am I doing wrong?

error 3.png

11

Looks like the PostgreSQL server process is not running after the reboot. How did you install PostgreSQL anway? If you used the official installer, the service should auto-start at boot.

12

I used the official installer from http://www.postgresql.org/. When I run pgAdmin III I get connection failed, without any further detail…

13

Check the Windows Services list if the service is started (and set to automatic).