Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple clusters with same tablespace location - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Multiple clusters with same tablespace location
Date
Msg-id CANu8FiyGM8COT0H4k_xCRE73rnLH1-ZJLbkdQUHM5aSFGGy0bQ@mail.gmail.com
Whole thread Raw
In response to Multiple clusters with same tablespace location  (Nate Dudenhoeffer <ndudenhoeffer@gmail.com>)
Responses Re: Multiple clusters with same tablespace location  (Nate Dudenhoeffer <ndudenhoeffer@gmail.com>)
List pgsql-general
Tree view


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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Unix Postgres 9.5. using pg_basebackup and WAL files. Can't get a PITR recovery
Next
From: Nate Dudenhoeffer
Date:
Subject: Re: Multiple clusters with same tablespace location