public inbox for [email protected]  

help / color / mirror / Atom feed
From: Tim Gerber <[email protected]>
To: Ian Dauncey <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Creating a new database on a different file system
Date: Mon, 17 Mar 2025 09:51:55 -0500
Message-ID: <CAPKih1wGSz4oAL+8hn6F=8gW4ZGCm+CEmLzARDmUFOXYSJuioQ@mail.gmail.com> (raw)
In-Reply-To: <AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>
References: <AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>

Hi Ian,

Tablespaces would work... take a look:
https://www.postgresql.org/docs/current/manage-ag-tablespaces.html

Best,
Tim

On Mon, Mar 17, 2025 at 9:49 AM Ian Dauncey <[email protected]>
wrote:

> 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
>
>
>
>
>


view thread (2+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Creating a new database on a different file system
  In-Reply-To: <CAPKih1wGSz4oAL+8hn6F=8gW4ZGCm+CEmLzARDmUFOXYSJuioQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox