On Wed, Jul 20, 2016 at 10:59 AM, Nate Dudenhoeffer <ndudenhoef...@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.
