Hba conf where is

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. 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. Couldn't find postgresql. Asked 6 years, 1 month ago. Active 5 months ago. Viewed k times. But when I try to configure the phpPgAdmin , I couldn't find the files postgresql. Improve this question. Is there a postgres user? Can you try: sudo su - postgres? 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. Otherwise, this is the name of a specific database user. 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