From: | Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | tablespace directories |
Date: | 2013-02-05 13:38:59 |
Message-ID: | CAKwGa_8=pMXnfKK4x_Jsi=bFAeRhh-y+y60KC2wB7sFfefStvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bèrto ëd Sèra | 2013-02-05 13:44:40 | Re: tablespace directories |
Previous Message | Bèrto ëd Sèra | 2013-02-05 13:31:39 | Re: DEFERRABLE NOT NULL constraint |