Error connecting to Postgres remotely

0

I'm having problems connecting to the company database, I'm accessing from home. My other colleagues can access it normally.

Both pgAdmin and terminal have been experiencing a problem. Strange that I can access other services like SVN or Redmine .

diego@diego-ThinkPad-X230:~$ sudo su postgres
[sudo] password for diego: 
postgres@diego-ThinkPad-X230:/home/diego$ psql -h paradigmainternet.ddns.com.br -p 5432
psql: could not connect to server: Não há rota para o host
    Is the server running on host "<endereço>" (<ip>) and accepting
    TCP/IP connections on port 5432?

Where I put <endereço> and <ip> refer to the address ddns and ip where I removed them for security.

I would like to know if there is something to do to connect because I can not access the postgres database from here

    
asked by anonymous 15.05.2015 / 20:45

1 answer

1

You need to release the permission on the file:

/var/lib/pgsql/data/pg_hba.conf

Add a line to release an address or range of IPs:

host    all         all         192.168.94.0 255.255.255.0      md5

In doubt about the documentation: link

    
15.05.2015 / 20:52