Re: Alternate Datafile Location

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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@xxxxxxxxxxxxxxxx> wrote:
> On Aug 29, 2024, at 5:29 PM, Sam Stearns <sam.stearns@xxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux