Hi Michael,
In the PostgreSQL data directory on the server, there is a file called "pg_hba.conf". (It stands for PostgreSQL "Host Based Access" configuration I think)
This file contains the list of IP addresses plus user names and databases that people are allowed to connect to remotely. The error you're getting indicates that you've connected to the database server, but it's not letting you actually "get in" because your IP address, user name (and so on) isn't listed in this configuration file.
You'll need to add your details there, then tell the PostgreSQL server to reload this configuration file:
$ pg_ctl reload
The configuration file itself is quite a lot of verbose text, describing how to add entries in there. Generally you can just copy an existing entry and change it appropriately.
Hope that helps.
Regards and best wishes,
Justin Clift
Michael J Martin wrote:
Just to mention the error I get is not a 'process isn't running' error it is:
Error connecting to the server: FATAL: no pg_hba.conf entry for host "212.159.49.21", user "mike", database "template1", SSL off
Hope this helps.
Michael
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
