Re: Differing data directories

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Differing data directories
Дата
Msg-id CAKFQuwarkyefOo5YPb+d60emn0v9=ROHq-w18pinVPVcTFnELA@mail.gmail.com
обсуждение исходный текст
Ответ на Differing data directories  ("Ron Watkins" <rwatki@gmail.com>)
Список pgsql-novice
On Thu, Feb 22, 2018 at 9:28 AM, Ron Watkins <rwatki@gmail.com> wrote:

I have a postgresql server setup/installed (finally).

Currently, it’s installed data directory is: /var/lib/pgsql/10/data

However, I need to put a database into a custom filesystem.

Is it possible to have multiple PGDATA directories, and if so, how?

 

Currently, the postgres database is under /var/lib/pgsql/10/data, but I need my main database to be in a different filesystem…



Short answer, just "initdb" a new cluster and point it to the desired location.​


Now, the answer becomes longer since you will now have two clusters.  You will either want to remove the existing one or ensure the two play nicely.  It is further complicated by the means by which you installed and what services have been setup.

All databases in a cluster share the same storage location by default though you can create tablespaces and put different databases on different tablespaces.  But that likely adds more complexity to the running setup than you need - at least by creating a new cluster and getting it to work properly you only need to deal with complexity during the initial setup.

David J.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Ron Watkins"
Дата:
Сообщение: Differing data directories
Следующее
От: "Ron Watkins"
Дата:
Сообщение: New DB cluster.