Postgres where is pg hba.conf

Improve this answer. Saved my day. It's working for postgres 9. In CentOS 7. Below query will help to find postgres configuration file. Srikant Patra Srikant Patra 2 2 bronze badges. I am also using CentOS7. I'm on CentOS 7 and I had to run initdb to generate postgresql. Feriman Feriman 1 1 gold badge 7 7 silver badges 11 11 bronze badges. Awais Nasir Awais Nasir 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? You can't even rely on asking where the datadir is and parsing postgresql. This command must be run on a superuser session, so for shell scripting you might write something like:.

Another option is to look at the ps command's output and see if the postmaster data directory argument -D is visible there, e. If you have more than one data directory for the same PostgreSQL version you'll have to look at database size, check the command line of the running postgres from ps to see if it's data directory -D argument matches where you're editing, etc. Ubuntu Community Ask! Sign up to join this community.

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question. Asked 8 years, 9 months ago. Active 7 months ago. Viewed k times. I'm using bash. Improve this question. Roger Dahl Roger Dahl 1, 2 2 gold badges 11 11 silver badges 11 11 bronze badges. Pramod There could tens of them lying around.

A separate file containing user names can be specified by preceding the file name with. Specifies the client machine address es that this record matches. This field can contain either a host name, an IP address range, or one of the special key words mentioned below. The mask length indicates the number of high-order bits of the client IP address that must match. Bits to the right of this should be zero in the given IP address. Typical examples of an IPv4 address range specified this way are To specify a single host, use a mask length of 32 for IPv4 or for IPv6.

In a network address, do not omit trailing zeroes. Note that entries in IPv6 format will be rejected if the system's C library does not have support for IPv6 addresses. You can also write all to match any IP address, samehost to match any of the server's own IP addresses, or samenet to match any address in any subnet that the server is directly connected to.

If a host name is specified anything that is not an IP address range or a special key word is treated as a host name , that name is compared with the result of a reverse name resolution of the client's IP address e.

Host name comparisons are case insensitive. If there is a match, then a forward name resolution e. If both directions match, then the entry is considered to match.

Some host name databases allow associating an IP address with multiple host names, but the operating system will only return one host name when asked to resolve an IP address. A host name specification that starts with a dot. It can be of advantage to set up a local name resolution cache such as nscd. Occasionally, users have wondered why host names are handled in this seemingly complicated way with two name resolutions and requiring reverse lookup of IP addresses, which is sometimes not set up or points to some undesirable host name.

It is primarily for efficiency: A connection attempt requires two resolver lookups of the current client's address. If there is resolver problem with that address, it becomes only that client's problem. That would already be slow by itself.

And if there is a resolver problem with one of the host names, it becomes everyone's problem. Also, a reverse lookup is necessary to implement the suffix matching feature, because the actual client host name needs to be known in order to match it against the pattern.

This field only applies to host , hostssl , and hostnossl records. Instead of specifying the mask length, the actual mask is specified in a separate column. For example, These fields only apply to host , hostssl , and hostnossl records. Specifies the authentication method to use when a connection matches this record.