How can I find where Postgres 8.x database files are saved in Ubuntu 10.04 file system?
+1
A:
In the data directory, just execute this query:
SHOW data_directory;
Check also the Ubuntu manual: https://help.ubuntu.com/10.04/serverguide/C/postgresql.html
Frank Heikens
2010-08-12 12:11:04
> In the data directory??
Mithun P
2010-08-12 12:32:13
Do i need to execute the SHOW command from the postgres prompt?
Mithun P
2010-08-12 12:33:10
Execute this query just like you execute all queries. You could use pgAdmin, psql or whatever client you use. But, why do you need these files? And did you read the Ubuntu manual?
Frank Heikens
2010-08-12 12:40:36
Thanks i got it!
Mithun P
2010-08-12 12:47:31