Tony Caduto wrote: [question about finding data directory]
I found it in the pg_settings view, but if there is another way I would like to know about it.
As Tom aluded, you can also do this:
regression=# select current_setting('data_directory');
current_setting
---------------------------
/usr/local/pgsql-8.0/data
(1 row)
Joe
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
