Re: initdb when data/ folder has mount points

2018-02-22 Thread Ron Johnson
On 02/22/2018 07:22 AM, David Steele wrote: On 2/22/18 1:16 AM, Michael Paquier wrote: On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote: On 2/21/18 7:01 PM, Tom Lane wrote: For pg_log, just put it somewhere else and set the appropriate configuration option to say where to write the

Re: initdb when data/ folder has mount points

2018-02-22 Thread David Steele
On 2/22/18 1:16 AM, Michael Paquier wrote: > On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote: >> On 2/21/18 7:01 PM, Tom Lane wrote: >>> For pg_log, just put it somewhere else and set the appropriate >>> configuration option to say where to write the postmaster log files. >>> Or you co

Re: initdb when data/ folder has mount points

2018-02-21 Thread Michael Paquier
On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote: > On 2/21/18 7:01 PM, Tom Lane wrote: >> For pg_log, just put it somewhere else and set the appropriate >> configuration option to say where to write the postmaster log files. >> Or you could use a symlink, like the solution for pg_xlog,

Re: initdb when data/ folder has mount points

2018-02-21 Thread David Steele
On 2/21/18 7:01 PM, Tom Lane wrote: Ron Johnson 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.

Re: initdb when data/ folder has mount points

2018-02-21 Thread Tom Lane
Ron Johnson writes: > On 02/21/2018 06:01 PM, Tom Lane wrote: >> Ron Johnson 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 >>>

Re: initdb when data/ folder has mount points

2018-02-21 Thread Ron Johnson
On 02/21/2018 06:01 PM, Tom Lane wrote: Ron Johnson 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

Re: initdb when data/ folder has mount points

2018-02-21 Thread Tom Lane
Ron Johnson 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. There's no reason for backu

Re: initdb when data/ folder has mount points

2018-02-21 Thread Rich Shepard
On Wed, 21 Feb 2018, Ron Johnson wrote: 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 Ron, What command do you use?