From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Changing the value of data_directory |
Date: | 2015-07-24 13:42:37 |
Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC07093C25@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2015-07-27 12:31:25 | Re: Changing the value of data_directory |
Previous Message | DWebb | 2015-07-21 17:43:03 | Re: pgloader CSV to table column formatting |