Databases maintenance operations#
Maintenance operations on databases, such as
VACUUM can be
run through the
pglift database run command.
$ pglift database -i 13/main run -d myapp "ANALYZE VERBOSE"
ANALYZE VERBOSE on database “myapp” of instance 13/main.
$ pglift database -i 13/main run -x test "VACUUM FULL VERBOSE"
VACUUM FULL VERBOSE on all databases of instance 13/main
except the one named “test”.