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 ?
Thanks a lot
on my system i am seeing something like:
PG_9.2_201202083
Its basically generated as:
"PG_ <PG_MAJORVERSION>_<CATALOG_VERSION_NO>"
Further you can check these values with pg_controldata as:
./pg_controldata db/data
pg_control version number: 922
Catalog version number: 201202083
Database system identifier: 5732255266599944159
....
--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company