Where is a postgresql 9.1 database stored in ubuntu 12.04?
- by celenius
I installed and created a Postgresql database on ubuntu. I then created the database using the following command:
sudo su postgres createdb mydatabase
However, I can't figure out where the database was initialized. I would like to be able to edit the hba.conf file and postgresl.conf files.
When I view the database using pgadmin I see the following information:
CREATE DATABASE mydatabase
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
Any thoughts on how I can find the database cluster location?