Where is pg hba.conf located ubuntu

Connect and share knowledge within a single location that is structured and easy to search. Where are the files postgresql. HBA stands for host-based authentication. Note it says stored in the database cluster's data directory and that it's possible to place it elsewhere, via a configuration parameter.

Official documentation cannot point you to a specific folder because the actual location depends on both how the OS maker and the machine's administrator have set PostgreSQL up. As Neutrino shows , if you can access your server via psql, you can tell it to show you the file location. Your package management sofware will tell you where are the files installed by each package, for example: dpkg -L postgresql.

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. Location of postgresql. Asked 11 years, 5 months ago. Add a comment. Active Oldest Votes.

Improve this answer. Craig Ringer Craig Ringer 4, 1 1 gold badge 20 20 silver badges 15 15 bronze badges. This might not be valid for 9. This is the only answer that works if you have more than one version of PostgreSQL installed. Is there any hope for Postges to standardize this? That would help with installation headaches a lot ScottSkiles PostgreSQL doesn't control it, it's up to the packages and distributors, who all have strong and different opinions on where it should be.

Show 6 more comments. Simply ask from PostgreSQL. Feriman Feriman 4 4 bronze badges. Thank you, but this matches the solution already provided by CraigRinger — Roger Dahl. Seth 52k 41 41 gold badges silver badges bronze badges.

Active 3 hr before. Viewed times. What you want to do is ask PostgreSQL:. Open a command prompt. When they change the names of the config settings, or you want to see something else. You can test server connections from other machines by using the PostgreSQL client. First, create a replication user in the master to be used by the standby server:. Back up the current state of the master server:. To make sure it is working, go to the master server and run the following command:.

The answer may be that you have not initialized the database yet. Centos 6, Postgres 9. Besides the direct answer , you will probably want to check out the docs about Postgres config file locations. I like this thread because it documents the default locations for various postgresql.

However , I've also gotten in trouble by relying on those defaults on installations where they have specified alternate locations.

One way to find out where a particular config file is by querying the database directly:. I got this using the following sql command cited in this response here:.

If you have the postgres in a docker container, probably you are binding the. That command returns a json, look for somethig like. From which I conclude the file is created during initialisation of the data directory, and resides in the root of the data dir. If locate is missing in your linux then run sudo apt-get install locate to install locate first. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 11 years, 2 months ago. Active 4 months ago. Viewed k times. Improve this question. Kopezaur 58 10 10 bronze badges. Timur Sadykov Timur Sadykov 9, 6 6 gold badges 30 30 silver badges 43 43 bronze badges. In case you are looking for sql's start-up file, it is called. Sajeev The OP asked about the config file locations on Ubuntu.

Your answer refers to Windows.