Re: [ppa-users] Can connect from phpPgAmin but not from pgsql

[Karl O. P. <ko...@me...>]

On Thu, 12 Apr 2018 19:29:30 +0200
Sebastian Tarach <seb...@gm...> wrote:

> Sorry, I might have been not precise enough with my explanation.
> 
> I'm trying to connect to the database on the network - not a local
> one and unfortunately I don't have access to that database files and
> I won't but I've received its IP address, username with readonly
> access and his pw.
> 
> Command I'm trying to use it psql --host=<ip-address> --port=5432
> --username=username
> IP address I'm giving is the same as the one set in config.inc.php
> phpPgAdmin is running on my machine Windows 7 and it is able to
> connect nicely.
> Postgres version is: 9.5.3

You are running psql from the same machine as that running phpPgAdmin
(and its webserver)?

Try using telnet on the machine you're running psql on and see if
you can reach the host/port where PG is running.

On Unix this is: telnet <ip-address> <port>

Regards,

Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein