Re: Multiple clusters with same tablespace location

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Multiple clusters with same tablespace location
Дата
Msg-id CANu8FiyGM8COT0H4k_xCRE73rnLH1-ZJLbkdQUHM5aSFGGy0bQ@mail.gmail.com
обсуждение исходный текст
Ответ на Multiple clusters with same tablespace location  (Nate Dudenhoeffer <ndudenhoeffer@gmail.com>)
Ответы Re: Multiple clusters with same tablespace location  (Nate Dudenhoeffer <ndudenhoeffer@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Wed, Jul 20, 2016 at 10:59 AM, Nate Dudenhoeffer <ndudenhoeffer@gmail.com> wrote:
What happens if I have two postgresql clusters running on the same server each with a tablespace pointing at the same location?

I have a production server, where I intend to move some tables to a second tablespace. I have a development/qa server which has multiple clusters running, each with a restore from the production server.

Thanks in advance,
Nate

Pointing multiple clusters to the same tablespace is a very bad idea. You run the risk of overwriting a file with the same name from a different cluster.
Think of Ghostbusters ->"Don't cross the streams"!.
There is no reason why you cannot have separate directories for each cluster/tablespace, so why ask for trouble?

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Unix Postgres 9.5. using pg_basebackup and WAL files. Can't get a PITR recovery
Следующее
От: Nate Dudenhoeffer
Дата:
Сообщение: Re: Multiple clusters with same tablespace location