Re: - tablespace and directory
| От | Raghavendra |
|---|---|
| Тема | Re: - tablespace and directory |
| Дата | |
| Msg-id | CA+h6Ahh-XvoOTWj7n8o3kXP0dL0wG2kWOriOetWyDG3UOsmMJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | - tablespace and directory ("F. BROUARD / SQLpro" <sqlpro@club-internet.fr>) |
| Ответы |
Re: - tablespace and directory
Re: - tablespace and directory |
| Список | pgsql-general |
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 ?
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
В списке pgsql-general по дате отправления: