Enabling access for network/remote users
PostgreSQL comes in a variety of distributions. In many of these, you will notice that remote access is initially disabled as a security measure.
How to do it…
By default, PostgreSQL gives access to clients who connect using Unix sockets, provided the database user is the same as the system's username. Here, we'll show you how to enable other connections.
Note
In this recipe, we mention configuration files, which can be located as shown in the Finding the current configuration settings recipe in Chapter 3, Configuration.
The steps are as follows:
- Add or edit this line in your
postgresql.conf
file:listen_addresses = '*'
- Add the following line as the first line of
pg_hba.conf
to allow access to all databases for ...
Get PostgreSQL 9 Administration Cookbook - Second Edition 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.