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: #1 - Known bug (memory related) with respect to Aurora postgresql 13.16.3

2025-03-17 Thread Ron Johnson
Aurora is very nonstandard. Thus, "we" don't support it. Having said that... "report running out of memory" smells like work_mem is set too high. On Mon, Mar 17, 2025 at 3:12 PM Bharani SV-forum wrote: > Team > Any one faced similar issue with Ver 13.16.X > > > > - Forwarded Message -

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

Restoring only a subset of schemas

2025-03-17 Thread Sylvain Cuaz
Hi all,     I have a DB with one schema named "Common" holding data referenced by other schemas. All other schemas have the same structure (tables and fields) and are named "cXXX" where XXX is just an int. Thus the only cross-schema foreign keys are in "cXXX" pointing to "Common", and each "cXX

Re: Restoring only a subset of schemas

2025-03-17 Thread Tom Lane
Sylvain Cuaz writes: >     Now if I want to restore from a full dump of this DB, but with only one > "cXXX" and the "Common" > schema : > - if I pass --create --schema=Common, then the CREATE SCHEMA is missing, i.e. > it only emits data > inside "Common" and the restore fails. > - if I could

Re: Restoring only a subset of schemas

2025-03-17 Thread Adrian Klaver
On 3/17/25 07:57, Sylvain Cuaz wrote: Hi all,     I have a DB with one schema named "Common" holding data referenced by other schemas. All other schemas have the same structure (tables and fields) and are named "cXXX" where XXX is just an int. Thus the only cross-schema foreign keys are in "

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