Re: Different Data Directories For Different Databases In One Instance

From: Keith <keith(at)keithf4(dot)com>
To: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Different Data Directories For Different Databases In One Instance
Date: 2024-04-18 13:08:01
Message-ID: CAHw75vt86xU+WTq1jp_kisqkBzrXTse+KfPHNva8f-W=efDYoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Apr 18, 2024 at 9:04 AM Phani Prathyush Somayajula <
phani(dot)somayajula(at)pragmaticplay(dot)com> wrote:

> Hi @pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)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 ?
>
>
>
> Or if not, can you suggest me a work-around to achieve this
>
>
>
> Regards,
>
> Phani
>
>
>

Look into tablespaces

https://www.postgresql.org/docs/current/manage-ag-tablespaces.html

Keith

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-04-18 13:09:02 Re: Different Data Directories For Different Databases In One Instance
Previous Message Phani Prathyush Somayajula 2024-04-18 13:04:32 Different Data Directories For Different Databases In One Instance