Re: Help with remote connection to remote Postgresql 8.3 Server...

On May 29, 5:17 am, hobbes <calvin(dot)ch(dot)(dot)(dot)(at)od-eon(dot)com> wrote:
> Hi Guys,
>
> I have been trying to get my local (windows) machine's PgAdmin II to
> connect directly to a remote Linux (Debian) Server where Postgresql
> 8.3 is installed.
>
> I have set in my postgresql.conf (remote):
>
> listen_addresses = '*' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
> # (change requires restart)
> port = 5432 # (change requires restart)
> max_connections = 100 # (change requires restart)
>
> and set in my pg_hba.conf (remote):
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> # "local" is for Unix domain socket connections only
> local all postgres trust
> local all all md5
>
> # IPv4 local connections:
> host all all 0.0.0.0/0 md5
> hostssl all all 0.0.0.0/0 md5
>
> # IPv6 local connections:
> host all all ::1/128 md5
>
> But I am still unable to connect to the server using the "postgres"
> user.
> Could some one enlighten me what I could be doing wrongly?
>
> Thanks...

It was a firewall issue. Using iptables to unblock it worked.

Thanks!