Re: - tablespace and directory

From: Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com>
To: "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: - tablespace and directory
Date: 2012-04-18 13:40:06
Message-ID: CAPtHcnGU22kZzWFBL=zxeQFLzVk7CAPZA+9T0vjVbjGKDL1HNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message F. BROUARD / SQLpro 2012-04-18 13:50:36 Re: - tablespace and directory
Previous Message F. BROUARD / SQLpro 2012-04-18 13:39:17 Re: - tablespace and directory