Changing the value of data_directory

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

In response to

Responses

Browse pgsql-novice by date

  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