Re: Alternate Datafile Location

[postgres(at)thiludbapql01 ~]$ createdb baptest -D /PGDATA
createdb: error: database creation failed: ERROR: tablespace "/PGDATA"
does not exist
[postgres(at)thiludbapql01 ~]$

The directory /PGDATA exists.

[postgres(at)thiludbapql01 ~]$ df -h /PGDATA
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/pgdatavg-pgdatavol 2.3T 28K 2.2T 1% /PGDATA
[postgres(at)thiludbapql01 ~]$

On Fri, Aug 30, 2024 at 9:03 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:

> > On Aug 29, 2024, at 5:29 PM, Sam Stearns <sam(dot)stearns(at)dat(dot)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
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>