On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro < sql...@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 Website: www.enterprisedb.com EnterpriseDB Blog : http://blogs.enterprisedb.com Follow us on Twitter : http://www.twitter.com/enterprisedb
