Re: Different Data Directories For Different Databases In One Instance

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Different Data Directories For Different Databases In One Instance
Дата
Msg-id CANzqJaBhHEybkwaToeWDSxZ1sax8h_xMwL-a7ihMFg_zy_FSqQ@mail.gmail.com
обсуждение исходный текст
Ответ на Different Data Directories For Different Databases In One Instance  (Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>)
Ответы Re: Different Data Directories For Different Databases In One Instance  (MichaelDBA <MichaelDBA@sqlexec.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Keith
Дата:
Сообщение: Re: Different Data Directories For Different Databases In One Instance
Следующее
От: MichaelDBA
Дата:
Сообщение: Re: Different Data Directories For Different Databases In One Instance