Обсуждение: What is the 'data2' directory for?

I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory
as a peer to the 'data' directory I specified at database initialization.
What is this directory for and what parameter determines its location?


--

On Tue, Oct 25, 2016 at 06:03:43PM -0400, Steven Hirsch wrote:
> I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory as
> a peer to the 'data' directory I specified at database initialization. What
> is this directory for and what parameter determines its location?

I am guessing someone at your site created it --- Postgres does not
create such directories by default.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

Steven Hirsch <snhirsch@gmail.com> writes:
> I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory
> as a peer to the 'data' directory I specified at database initialization.
> What is this directory for and what parameter determines its location?

Postgres itself certainly does no such thing.  Maybe it's being done in
some wrapper script you're using?

            regards, tom lane

On Tue, 25 Oct 2016, Tom Lane wrote:

> Steven Hirsch <snhirsch@gmail.com> writes:
>> I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory
>> as a peer to the 'data' directory I specified at database initialization.
>> What is this directory for and what parameter determines its location?

> Postgres itself certainly does no such thing.  Maybe it's being done in
> some wrapper script you're using?

<sigh..> My boneheadedness is responsible for 'data2'.  I had forgotten
that I created a new tablespace there in anticipation of putting a
particularly large database on its own mount point.



--