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
