Creating a new database on a different file system

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

Responses

Browse pgsql-general by date

  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