Postgres Pro
Downloads
Home   >   mailing lists

Re: - tablespace and directory - Mailing list pgsql-general

From Raghavendra
Subject Re: - tablespace and directory
Date
Msg-id CA+h6Ahh-XvoOTWj7n8o3kXP0dL0wG2kWOriOetWyDG3UOsmMJg@mail.gmail.com
Whole thread Raw
In response to - tablespace and directory  ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>)
Responses Re: - tablespace and directory  ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>)
Re: - tablespace and directory  ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>)
List pgsql-general
Tree view


On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro <sqlpro@club-internet.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

pgsql-general by date:

Previous
From: "F. BROUARD / SQLpro"
Date:
Subject: - tablespace and directory
Next
From: "F. BROUARD / SQLpro"
Date:
Subject: Re: - tablespace and directory