From: | Tim Gerber <tggerber(at)gmail(dot)com> |
---|---|
To: | Ian Dauncey <Ian(dot)Dauncey(at)bankzero(dot)co(dot)za> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Creating a new database on a different file system |
Date: | 2025-03-17 14:51:55 |
Message-ID: | CAPKih1wGSz4oAL+8hn6F=8gW4ZGCm+CEmLzARDmUFOXYSJuioQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <Ian(dot)Dauncey(at)bankzero(dot)co(dot)za>
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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sylvain Cuaz | 2025-03-17 14:57:04 | Restoring only a subset of schemas |
Previous Message | Luca Ferrari | 2025-03-17 14:51:19 | Re: Creating a new database on a different file system |