Shulou(Shulou.com)06/01 Report--

Editor to share with you how to back up VCSA built-in Postgresql database, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

First, log in to the VCSA server remotely on the command line, and then execute the following command to stop vmware-vpxd, the core service of VCSA:

VCenterServerAppliance:~ # service vmware-vpxd stop

Stopping VMware vSphere Profile-Driven Storage Service...

Stopped VMware vSphere Profile-Driven Storage Service. (o0w8 T3 k: r

Stopping tomcat: success) {# T-u $^ (\ 4 l; F "I. [

Stopping vmware-vpxd: success

Shutting down ldap-server..done

2. Then, execute the following command to go to the bin directory of postgresql:

# cd / opt/vmware/vpostgres/1.0/bin

3. Execute the cat command to view the configuration information of DB:

VCenterServerAppliance:/opt/vmware/vpostgres/1.0/bin # cat / etc/vmware-vpx/embedded_db.cfg

EMB_DB_INSTALL_DIR='/opt/vmware/vpostgres/9.0'

EMB_DB_TYPE='PostgreSQL'

EMB_DB_SERVER='127.0.0.1'

EMB_DB_PORT='5432'

EMB_DB_INSTANCE='VCDB'

EMB_DB_USER='vc'

EMB_DB_PASSWORD='7Uz ($Q4tY6'

EMB_DB_STORAGE='/storage/db/vpostgres'

4. Record the user and password in step 3, and then execute the following command to start the backup:

VCenterServerAppliance:/opt/vmware/vpostgres/1.0/bin #. / pg_dump VCDB-U vc-Fp-c > / tmp/VCDBbackup

5. After the backup is completed, you can restart the service.

# service vmware-vpxd start

The above is all the contents of the article "how to back up VCSA's built-in Postgresql database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.