| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | Nate Dudenhoeffer <ndudenhoeffer(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Multiple clusters with same tablespace location |
| Date: | 2016-07-20 15:34:46 |
| Message-ID: | CANu8FiyGM8COT0H4k_xCRE73rnLH1-ZJLbkdQUHM5aSFGGy0bQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 20, 2016 at 10:59 AM, Nate Dudenhoeffer <ndudenhoeffer(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nate Dudenhoeffer | 2016-07-20 15:48:14 | Re: Multiple clusters with same tablespace location |
| Previous Message | Jeff Janes | 2016-07-20 15:03:47 | Re: Unix Postgres 9.5. using pg_basebackup and WAL files. Can't get a PITR recovery |