PostgreSQL - Where is a postgresql 9.1 database stored in ubuntu 12.04?

Support
Support
5000
| 2 1 2
Asked on 8/28/15, 11:02 AM
0
vote
2547 Views

The postgres.conf file is located here: /etc/postgresql/9.1/main/postgres.conf. In postgres.conf can see a line stating data_directory=<path>

This is the directory where your database files are stored

Alternatively when you are connected to database use

SHOW data_directory

or

pg_lsclusters

to show the directory where your data is stored.

ALSO

ps auxw|grep postgres|grep -- -D

returns:

/usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf

on Ubuntu 14.04. That command will work on other variants like Fedora

Support
Support
5000
| 2 1 2
Answered on 8/28/15, 11:02 AM
0
vote

Your answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

Ask a Question

Keep Informed

About This Forum

This forum is for HiTechnologia Employees & just Odoo general knowledge purpose only.

Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 8/28/15, 11:02 AM
Seen: 2547 times
Last updated: 8/28/15, 11:02 AM