Error connecting Postgres to remotely

Question

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

Both saw pgAdmin how much terminal I have been facing 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 was wondering if there’s something to do to connect because I can’t access the postgres database from home

Answer 1

You need to release the permission in the file:

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

Add a line to release an IP address or range:

host    all         all         192.168.94.0 255.255.255.0      md5

At doubt of a look at the documentation: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html