Hi all, I have to monitor a number of pg physical files based on writing access time. All fine, stats does it. I do, however, have a problem in finding out where the files are. To get a list I'm using select oid, spcname, pg_tablespace_location(oid) from pg_tablespace however, the location is shorter then I would need (it simply records how tblspcs were created). My files are at <creation path>/PG_9.2_201204301/417519 and I am quite struggling to understand how this final PG_9.2_201204301/417519 part is generated. Is there any way I can dig it out from the catalog? Cheers Bèrto -- ============================== If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
