From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade & tablespaces |
Date: | 2013-12-27 22:07:51 |
Message-ID: | 52BDFA37.5080209@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 12/27/2013 01:56 PM, Joseph Kregloh wrote:
> FYI, some testing showed that playing around with spclocation in
> pg_tablespace is not recommended.
>
>
> Do you happen to have more information about this? Because it would
> actually solve all my problems by moving the user created tablespaces
> out of the /data directory. But I would like more information on the
> subject before even thinking about it anymore. I did it a couple times
> for testing purposes. I modified the spclocation in pg_tablespace and
> then move the folder.
Well as a general idea manually altering system catalogs is a bad idea.
I just did some quick tests on something that was not as complex as your
setup and for me it did not go well. I could make changes, but when I
tried to use the tablespaces I got all sort of errors. Could be just me,
still this is a path into deep dark places, you are warned:)
>
> -Joseph
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-12-27 22:34:52 | Re: pg_upgrade & tablespaces |
Previous Message | Joseph Kregloh | 2013-12-27 21:56:53 | Re: pg_upgrade & tablespaces |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2013-12-27 22:09:09 | Re: preserving forensic information when we freeze |
Previous Message | Kevin Grittner | 2013-12-27 22:03:08 | Re: [BUG FIX] Version number expressed in octal form by mistake |