Postgres Pro
Downloads
Home   >   mailing lists

Re: Different Data Directories For Different Databases In One Instance - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Different Data Directories For Different Databases In One Instance
Date
Msg-id CANzqJaBhHEybkwaToeWDSxZ1sax8h_xMwL-a7ihMFg_zy_FSqQ@mail.gmail.com
Whole thread Raw
In response to Different Data Directories For Different Databases In One Instance  (Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>)
Responses Re: Different Data Directories For Different Databases In One Instance
List pgsql-admin
Tree view
On Thu, Apr 18, 2024 at 9:04 AM Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com> wrote:

Hi @pgsql-admin@lists.postgresql.org ,

 

I have 2 mounts /data/feed  & /data/bets

I have postgres-dev server on which I have 6 feed databases (let’s say a,b,c,d,e,f) and 4 bets databases(lets say g,h,i,j)

I want to group the data directories based on the databases, and they all should be running from the same instance. Can I achieve this ?


Tablespaces.
 

 Or if not, can you suggest me a work-around to achieve this


Symlinks.  But tablespaces are the canonical solution.

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: Different Data Directories For Different Databases In One Instance
Next
From: MichaelDBA
Date:
Subject: Re: Different Data Directories For Different Databases In One Instance