Moreno Andreo wrote:
> Now, 2 questions.
> 1. Is it all or do I need to adjust something else about permissions,
> indexes, vacuuming, etc...?
> ALTERing the database namespace means copying its physical files to new
> directory, but is it applied to all objects (indexes, triggers, etc)?
All objects that are located in the default tablespace of the database
will be moved.
> 2. What will happen to who tries to access the database while it's being
> moved from one tablespace to another?
They will be "hanging" with a lock until the transaction is done.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com