I'm doing a vacuum full in my postgres server and I have some issues, so I would like to lock all "postgres" database in my postgresql server. I would not lock juste table.
How can I do that ?
thanks.
Asked
Active
Viewed 46 times
0
-
vacuum full locks table itself - what issue you have?.. – Vao Tsun Jan 08 '18 at 10:45
-
If you want to keep users from connecting to the database, lock them out in `pg_hba.conf`, reload the server and kill all active connections. – Laurenz Albe Jan 08 '18 at 10:49
-
@VaoTsun vacuum full blocks just table on which it works at a time T but other tables can be used and when it wants to take the lock it can't do it – Jan 08 '18 at 11:00
-
@LaurenzAlbe Okey I will try that, thanks – Jan 08 '18 at 11:01
-
@Carlinto ah - I see - makes sense – Vao Tsun Jan 08 '18 at 11:02
-
See [here](https://dba.stackexchange.com/q/161922/1822) or [here](https://dba.stackexchange.com/q/183982/1822) or [here](https://dba.stackexchange.com/q/6122/1822) – Jan 08 '18 at 12:20