-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
CentOS 6 Linux Server Cookbook
By :
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.
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.
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...
Change the font size
Change margin width
Change background colour