Re: - tablespace and directory

AFAIK, I dont see any catalog's giving that information.

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

On Wed, Apr 18, 2012 at 7:20 PM, F. BROUARD / SQLpro <
sqlpro(at)club-internet(dot)fr> wrote:

> Hi,
>
> is there anyway to have the value of Catalog version number in a query ?
> I do not see it in pg_settings...
>
>
> A +
>
> Le 18/04/2012 15:35, Raghavendra a écrit :
>
>>
>>
>> On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro
>> <sqlpro(at)club-internet(dot)fr <mailto:sqlpro(at)club-internet(dot)**fr<sqlpro(at)club-internet(dot)fr>>>
>> wrote:
>>
>> Hi there,
>>
>> when creating a tablespace pointing to an existing directory, PG
>> create a subderictory with this pattern :
>>
>> PG_???_!!!!!!!!!
>>
>> where ??? is the version (by instance 9.1)
>>
>> but I don't know what is !!!!!!!!!, actually 201105231
>>
>> I can imagine that is a build version, but how can I obtain this
>> number by a SQL Query ?
>>
>>
>> Thats a system catalog version number. You can retrieve with
>> pg_controldata
>>
>> Eg:
>>
>> -bash-4.1$ ./pg_controldata
>> pg_control version number: 903
>> Catalog version number: 201105231
>> Database system identifier: 5719586032196955957
>> Database cluster state: in production
>>
>>
>> ---
>> Regards,
>> Raghavendra
>> EnterpriseDB Corporation
>> Blog: http://raghavt.blogspot.com/
>>
>>
>
> --
> Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
> Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
> Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
> Audit, conseil, expertise, formation, modélisation, tuning, optimisation
> *********************** http://www.sqlspot.com *************************
>
>