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
# "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
How Do I Enable Remote Access To PostgreSQL Database Server
Reviewed by vivek sathisan
on
14:45
Rating:

No comments: