From: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Cc: | Peter Garza <peter(dot)garza(at)dat(dot)com>, Henry Ashu <henry(dot)ashu(at)dat(dot)com> |
Subject: | Alternate Datafile Location |
Date: | 2024-08-29 23:11:26 |
Message-ID: | CAN6TVjn=4TOm7OLOw7VoOBY9+XVe2YcxV_z1xZtF-Qp_7gddvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Howdy,
Here's our filesystems:
[postgres(at)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(at)xxx data]$
Our Postgres software install and data directory is on root:
[postgres(at)xxx data]$ pwd
/var/lib/pgsql/16/data
[postgres(at)thiludbapql01 data]$ df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root 28G 4.5G 23G 17% /
[postgres(at)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
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-08-29 23:17:34 | Re: Alternate Datafile Location |
Previous Message | Scott Ribe | 2024-08-29 19:14:42 | Re: Postgresql Database and PG_WAL locations |