Postgres Pro
Downloads
Home   >   mailing lists

Re: Alternate Datafile Location - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Alternate Datafile Location
Date
Msg-id CAN6TVjm_ri4B5TRjuu-w3=OWoFPb+9Me1_zma8uDi0p4CTyALg@mail.gmail.com
Whole thread Raw
In response to Re: Alternate Datafile Location  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Alternate Datafile Location
Re: Alternate Datafile Location
List pgsql-admin
Tree view
[postgres@thiludbapql01 ~]$ createdb baptest -D /PGDATA
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 ~]$

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

DAT

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Alternate Datafile Location
Next
From: "David G. Johnston"
Date:
Subject: Re: Alternate Datafile Location