VMware Cloud Community
dlee2654
Enthusiast
Enthusiast

vc appliance postgres db volume full

our /storage/db is 100% and we have tried the command

sudo -u postgres /opt/vmware/vpostgres/1.0/bin/vacuumdb -a -e -v -f -U postgres /tmp/vacuumdb.log

the command returns error:

could not change directory to "/root"

vacuumdb: cannot vacuum all databases and a specific one at the same time.  researching this command is not revealing a working syntax.  any help appreciated.

we are following this article

VMware KB: Reclaiming space on VMware Postgres (vPostgres) databases within the VMware vCenter Serve...

thanks,

Reply
0 Kudos
1 Reply
npadmani
Virtuoso
Virtuoso

sudo -u postgres /opt/vmware/vpostgres/1.0/bin/vacuumdb -a -e -v -f -U postgres > /tmp/vacuumdb.log

above is the actual command with '>', are you using that or did you really miss that '>' (output redirection) to particular log file.

since the error is telling that what you are using is not working syntax. So I thought of pointing it to you.

Narendra Padmani VCIX6-DCV | VCIX7-CMA | VCI | TOGAF 9 Certified
Reply
0 Kudos