Re: Volume partitioning (was Re: pgbackrest when data/base issymlinked to another volume)

Hi Ron

On 9/8/18 4:26 PM, Ron wrote:
> 
> Googled "postgresql disk partitioning" and "postgresql volume 
> partitioning" without much success.
> 
> Is the best practice volume partitioning:
> /Database/9.6/data
> /Database/9.6/data/pg_log
> /Database/9.6/data/pg_xlog
> 
> where /var/lib/pgsql/9.6 (on RHEL6) is a symlink to /Database/9.6/data 
> and PGDATA=/Database/9.6/data
> 
> *or *
> 
> /Database/9.6/data/base
> /Database/9.6/data/pg_log
> /Database/9.6/data/pg_xlog
> 
> where PGDATA=/var/lib/pgsql/9.6/data and base, pg_log and px_xlog are 
> symlinks to the partitions?

This is really a matter of preference, but simpler is better, so the 
first one looks better to me.

In general I prefer to keep everything in /var/lib/pgsql/9.6:

/var/lib/pgsql/9.6/data
/var/lib/pgsql/9.6/data/pg_xlog -> /var/lib/pgsql/9.6/wal

Then use the log_directory setting to put logs in:

/var/log/pgsql or /var/lib/pgsql/9.6/log

pgBackRest will expect to be pointed at a real directory (pg-path) and 
expect the data_directory in PostgreSQL to match.

Regards,
-- 
-David
david@pgmasters.net