What is the 'data2' directory for?

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 +

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

--

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general