Re: pg_upgrade & tablespaces
| От | Jeff Janes |
|---|---|
| Тема | Re: pg_upgrade & tablespaces |
| Дата | |
| Msg-id | CAMkU=1x_XNcx+E1xcctPocFMSEPGdaZFWzf6yzxeOo9KXGYBWw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_upgrade & tablespaces (Joseph Kregloh <jkregloh@sproutloud.com>) |
| Ответы |
Re: pg_upgrade & tablespaces
|
| Список | pgsql-general |
On Friday, December 27, 2013, 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.
spclocation no longer exists in 9.3. If the database needs to know where the location is, it inspects the symlink in pg_tblspc to figure that out.
Cheers,
Jeff
В списке pgsql-general по дате отправления: