Re: Different Data Directories For Different Databases In One Instance

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "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:09:02
Message-ID: CANzqJaBhHEybkwaToeWDSxZ1sax8h_xMwL-a7ihMFg_zy_FSqQ@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 ?
>

Tablespaces.

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

Symlinks. But tablespaces are the canonical solution.

>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2024-04-18 13:28:57 Re: Different Data Directories For Different Databases In One Instance
Previous Message Keith 2024-04-18 13:08:01 Re: Different Data Directories For Different Databases In One Instance