Re: pgAdmin can't connect to port 5432

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