| From: | Raghavendra <raghavendra(dot)rao(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:35:18 |
| Message-ID: | CA+h6Ahh-XvoOTWj7n8o3kXP0dL0wG2kWOriOetWyDG3UOsmMJg@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 ?
>
>
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | F. BROUARD / SQLpro | 2012-04-18 13:39:17 | Re: - tablespace and directory |
| Previous Message | F. BROUARD / SQLpro | 2012-04-18 12:52:37 | - tablespace and directory |