How Do I Enable Remote Access To PostgreSQL Database Server

Connect postgreSQL Database from postgreSQL server

By default, PostgreSQL database server remote access disabled for security reasons.

For Installing and configuring Postgresql Server

Please refer http://www.nixstuffs.com/2016/07/how-to-install-and-configure-postgresql.html

To connect postgresql server add the following in servers configuration file below

#  vim /var/lib/pgsql/9.5/data/pg_hba.conf

Add the last line by replacing ipaddress and subnet of client server

If no password for postgres change ident to trust

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
     local   all             all                                            peer
# IPv4 local connections:
     host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
    host    all             all             ::1/128                      ident
    host    all             all             ipaddress subnet       ident