Alternate Datafile Location

[Sam Stearns <sam.stearns@xxxxxxx>]

Howdy,

Here's our filesystems:

[postgres@xxx data]$ df -h
Filesystem                      Size  Used Avail Use% Mounted on
devtmpfs                         80G     0   80G   0% /dev
tmpfs                            80G   44M   80G   1% /dev/shm
tmpfs                            80G  716K   80G   1% /run
tmpfs                            80G     0   80G   0% /sys/fs/cgroup
/dev/mapper/rhel-root            28G  4.5G   23G  17% /
tmpfs                            80G  8.0K   80G   1% /tmp
/dev/sda2                      1014M  457M  558M  46% /boot
/dev/sda1                       599M  5.9M  594M   1% /boot/efi
/dev/mapper/pgwalvg-pgwalvol    570G   28K  541G   1% /PG_WAL
/dev/mapper/pgdatavg-pgdatavol  2.3T   28K  2.2T   1% /PGDATA
tmpfs                            16G     0   16G   0% /run/user/1242651222
tmpfs                            16G     0   16G   0% /run/user/1271246868
[postgres@xxx data]$

Our Postgres software install and data directory is on root:

[postgres@xxx data]$ pwd
/var/lib/pgsql/16/data
[postgres@thiludbapql01 data]$ df -h .
Filesystem             Size  Used Avail Use% Mounted on
/dev/mapper/rhel-root   28G  4.5G   23G  17% /
[postgres@xxx data]$

We want our database datafile storage to be on /PGDATA.  I don't see anything in the version 16 documentation on how to accomplish this.  I must be missing it somewhere.  Could someone please advise?

Thanks,

Sam

--

Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com