Re: pg_upgrade & tablespaces - Mailing list pgsql-general

From Joseph Kregloh
Subject Re: pg_upgrade & tablespaces
Date
Msg-id CAAW2xfeiFbaKqHx5jpL=d6n8VukNYQ4GdTV1GVxTQxeOKPiigQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade & tablespaces  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: pg_upgrade & tablespaces  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: pg_upgrade & tablespaces  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
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.

-Joseph 

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Why is wal_writer_delay limited to 10s?
Next
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade & tablespaces