Configuring remote access to PostgreSQL
In this recipe we will learn how to configure local and remote access to PostgreSQL.
PostgreSQL can be configured to allow remote access and yet it is not always obvious how this can be achieved. PostgreSQL employs a method called Host Based Authentication and it is the purpose of this recipe to show you how to troubleshoot client authentication in order to provide the access rights you need to run a safe and secure database server.
Getting ready
To complete this recipe you will require a working installation of the CentOS 6 operating system with root privileges and a text editor of your choice. It is expected that PostgreSQL is already installed and running.
How to do it...
The PostgreSQL client authentication is controlled using a system known as host-based authentication and to make any changes we will need to access the main configuration file:
To do this, log in as root and open the Host Based Authentication configuration file in your favorite text...
