Improve this answer. Give a man a fish The right way is to know how to have postgres tell you where the file is. See neutrino's answer. If and only if you can access your running PostgreSQL instance. If your HBA file is messed up you might not be able to. I've linked to Neutrino's answer. How to find it at the remote server then?
Open a command prompt. Neutrino Neutrino 3 3 silver badges 3 3 bronze badges. Milen A. Radev Milen A. Radev 5 5 silver badges 17 17 bronze badges. As Vinko said, the location is distribution-dependent. 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. This field only applies to host , hostssl , and hostnossl records. Users sometimes wonder why host names are handled in this seemingly complicated way, with two name resolutions including a reverse lookup of the client's IP address. This complicates use of the feature in case the client's reverse DNS entry is not set up or yields some undesirable host name.
It is done primarily for efficiency: this way, a connection attempt requires at most two resolver lookups, one reverse and one forward. If there is a resolver problem with some address, it becomes only that client's problem. That could be quite slow if many names are listed. And if there is a resolver problem with one of the host names, it becomes everyone's problem.
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. Nantha kumar Nantha kumar 3 3 silver badges 7 7 bronze badges. ThinkBonobo ThinkBonobo Ardent Coder 3, 9 9 gold badges 22 22 silver badges 45 45 bronze badges.
Vladimir Kievsky Vladimir Kievsky 21 2 2 bronze badges. Emeeus Emeeus 4, 2 2 gold badges 16 16 silver badges 34 34 bronze badges. Gabriel Gabriel 4 4 silver badges 7 7 bronze badges. OS in question is Linux.
Saket Suraj Saket Suraj 71 1 1 silver badge 8 8 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?
Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 5. See more linked questions. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.
0コメント