Re: Creating a new database on a different file system

2025-03-17 Thread Ron Johnson
On Mon, Mar 17, 2025 at 4:30 PM Laurenz Albe wrote: > On Mon, 2025-03-17 at 14:33 -0400, Ron Johnson wrote: > > On Mon, Mar 17, 2025 at 11:18 AM Laurenz Albe > wrote: > > > On Mon, 2025-03-17 at 15:51 +0100, Luca Ferrari wrote: > > > > On Mon, Mar 17, 2025 at 3:49 PM Ian Dauncey < > ian.daun...@

Re: Creating a new database on a different file system

2025-03-17 Thread Ron Johnson
On Mon, Mar 17, 2025 at 11:18 AM Laurenz Albe wrote: > On Mon, 2025-03-17 at 15:51 +0100, Luca Ferrari wrote: > > On Mon, Mar 17, 2025 at 3:49 PM Ian Dauncey > wrote: > > > We have created a few databases on the file system defined in the > postgresql.conf, > > > but now I would like to create a

Re: Creating a new database on a different file system

2025-03-17 Thread Laurenz Albe
On Mon, 2025-03-17 at 14:33 -0400, Ron Johnson wrote: > On Mon, Mar 17, 2025 at 11:18 AM Laurenz Albe > wrote: > > On Mon, 2025-03-17 at 15:51 +0100, Luca Ferrari wrote: > > > On Mon, Mar 17, 2025 at 3:49 PM Ian Dauncey > > > wrote: > > > > We have created a few databases on the file system def

Re: Creating a new database on a different file system

2025-03-17 Thread Laurenz Albe
On Mon, 2025-03-17 at 15:51 +0100, Luca Ferrari wrote: > On Mon, Mar 17, 2025 at 3:49 PM Ian Dauncey > wrote: > > 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 > > d

Creating a new database on a different file system

2025-03-17 Thread Ian Dauncey
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 g

Re: Creating a new database on a different file system

2025-03-17 Thread Luca Ferrari
On Mon, Mar 17, 2025 at 3:49 PM Ian Dauncey wrote: > > 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

Re: Creating a new database on a different file system

2025-03-17 Thread Tim Gerber
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 wrote: > Hi All > > > > We are running an old version of PostgreSQL on a Linux Server. > > We have created a few databases on