Re: What is the 'data2' directory for?

From: Steven Hirsch <snhirsch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the 'data2' directory for?
Date: 2016-10-29 21:25:23
Message-ID: alpine.DEB.2.10.1610291723210.4473@z87
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 25 Oct 2016, Tom Lane wrote:

> Steven Hirsch <snhirsch(at)gmail(dot)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.

--

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-10-29 21:33:49 Re: Row level security performance joining large tables
Previous Message Adrian Klaver 2016-10-29 21:15:31 Re: Cannot access the return value of a PostgreSQL function using ADO