Re: Alternate Datafile Location - Mailing list pgsql-admin
[postgres@thiludbapql01 ~]$ createdb baptest -D /PGDATA
createdb: error: database creation failed: ERROR: tablespace "/PGDATA" does not exist
[postgres@thiludbapql01 ~]$
createdb: error: database creation failed: ERROR: tablespace "/PGDATA" does not exist
[postgres@thiludbapql01 ~]$
The directory /PGDATA exists.
[postgres@thiludbapql01 ~]$ df -h /PGDATA
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/pgdatavg-pgdatavol 2.3T 28K 2.2T 1% /PGDATA
[postgres@thiludbapql01 ~]$
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/pgdatavg-pgdatavol 2.3T 28K 2.2T 1% /PGDATA
[postgres@thiludbapql01 ~]$
On Fri, Aug 30, 2024 at 9:03 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Aug 29, 2024, at 5:29 PM, Sam Stearns <sam.stearns@dat.com> wrote:
>
> That's fine as long as we can create databases with datafile storage on an alternate filesystem. I don't see anywhere in the documentation how to do that.
-D <directory>
Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com
pgsql-admin by date: