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
