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 ...

Get CentOS 6 Linux Server Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.