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 ? > > 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/
