From: | Ian Dauncey <Ian(dot)Dauncey(at)bankzero(dot)co(dot)za> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Creating a new database on a different file system |
Date: | 2025-03-17 14:48:42 |
Message-ID: | AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All
We are running an old version of PostgreSQL on a Linux Server.
We have created a few databases on the file system defined in the postgresql.conf, but now I would like to create another database within the same cluster but on a different file system.
Is this possible and if so, how do we go about it.
In a nutshell:
I have the following statement defined in the postgresql.conf file - data_directory = '/opt/pgdata_postgres'
I have created the following database datadb1, datadb2 (plus all default databases)
Now I want to create a third database datadb3, but it needs to be created on file system "/opt/pgdata1_postgres" and not on '/opt/pgdata_postgres'
Is this possible
Regards
Ian
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2025-03-17 14:51:19 | Re: Creating a new database on a different file system |
Previous Message | Robert Treat | 2025-03-16 22:24:59 | Re: Disabling vacuum truncate for autovacuum |