tablespace directories

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.

Responses

Browse pgsql-general by date

  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