Il 16/10/2018 10:18, Laurenz Albe ha scritto:
> 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
Perfect!
Thanks for your time,
Moreno