Re: initdb when data/ folder has mount points - Mailing list pgsql-general

From Tom Lane
Subject Re: initdb when data/ folder has mount points
Date
Msg-id 5668.1519260436@sss.pgh.pa.us
Whole thread Raw
In response to Re: initdb when data/ folder has mount points  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Ron Johnson <ron.l.johnson@cox.net> writes:
> On 02/21/2018 06:01 PM, Tom Lane wrote:
>> Ron Johnson <ron.l.johnson@cox.net> writes:
>>> Apparently, initdb assumes that data/ is one big mount point. However, we
>>> have four mount points:
>>> /var/lib/pgsql/9.6/data/backup
>>> /var/lib/pgsql/9.6/data/base
>>> /var/lib/pgsql/9.6/data/pg_log
>>> /var/lib/pgsql/9.6/data/pg_xlog

>> Don't do that.

> I'm replicating the structure in our existing systems.  Is there an (up to 
> date) Best Practices document for these kinds of issues?

Well, initdb has never allowed a non-empty target (at least not in this
century).  So your existing setup must have been achieved by manual
hacking post-initdb, which you could certainly do again if you're dead
set on that layout.  I remain of the opinion that it's not a good
design, though.

            regards, tom lane


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: initdb when data/ folder has mount points
Next
From: Lucas Fairchild-Madar
Date:
Subject: Re: Understanding query planner cpu usage