Changing the value of data_directory
От | Birchall, Austen |
---|---|
Тема | Changing the value of data_directory |
Дата | |
Msg-id | 4E154FB60786D74BB4DFDC97BF991CAC07093C25@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk обсуждение исходный текст |
Ответ на | Re: PGDATA on Windows (Daniel Begin <jfd553@hotmail.com>) |
Ответы |
Re: Changing the value of data_directory
|
Список | pgsql-novice |
I'm not sure how they done it but our Platforms Team seem to have installed PostgreSQL 9.4.1 in both /var/lib/pgsql/data Which is want I want And /var/lib/pgsql/9.4/data/ Which is want I don't want! For most of our clusters we get: postgres=# SHOW data_directory; data_directory --------------------- /var/lib/pgsql/data (1 row) postgres=# but for a couple we get: postgres=# SHOW data_directory; data_directory --------------------- /var/lib/pgsql/9.4/data (1 row) postgres=# My questions are: 1. How/when is the value of data_directory set - is it set as part of the install? 2. Is it possible to change the value of data_directory without doing a frest install? Thanks Austen Austen Birchall Senior Database Administrator Met Office
В списке pgsql-novice по дате отправления: