top of page

Interacting with Embedded VPostgres Database

Writer's picture: vPvP

vCenter server requires a database to store and organize all the server data. Each vCenter Server must have it's own database.


For vCenter server installed on a Windows, we can either use PostgreSQL database or we can setup an external database before installing vCenter server. vCenter server for Windows supports Oracle and Microsoft SQL server as external databases.


For vCenter server Appliance, we can use the bundled PostgreSQL database that is included in the VCSA, which supports up to 1000 hosts and 10,000 virtual machines. For external database, VCSA supports only Oracle databases.


For information about supported database server versions, see the VMware Product Interoperability Matrix.


In this blog post, we will see how to interact with the VCSA embedded vPostgres Database. The commands used here are specific to the VCSA 6.5/6.7/7.0.


  1. Log into the VCSA as root via SSH.


2. Type shell to switch to the BASH Shell.


3. Connect to the VCDB by running this command from the VCSA BASH Shell -

/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres


Once you login to the postgres database, standard SQL commands can be used. Let's discuss few basic commands below.

1. To list all databases in the server run the following command - \l+


2. To list all tables, sequences, and views with size - \d+


3. To list all the functions of VCDB embedded database - \df


4. To quit the vpostgres database - \q


I hope this post is informative for you to start interacting with the VCSA Embedded VPostgres Database using the above basic commands.


Thanks for Reading!


***Explore | Share | Grow ***

58 views0 comments

Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
vp1.2_23.png

vPundit

Explore | Share | Grow

Thanks for submitting!

vPundit

bottom of page