On Wed, Jul 20, 2016 at 10:59 AM, Nate Dudenhoeffer <ndudenhoeffer@xxxxxxxxx> 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? Think of Ghostbusters ->"Don't cross the streams"!.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
