Connecting to the embedded vPostgres Database in a Windows installed vCenter Server 6.x
search cancel

Connecting to the embedded vPostgres Database in a Windows installed vCenter Server 6.x

book

Article ID: 340937

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

This article provides steps on connecting to the embedded vPostgres database in a Windows deployment of vCenter Server 6.x

Environment

VMware vCenter Server 6.7.x
VMware vCenter Server 6.0.x
VMware vCenter Server 6.5.x

Resolution

To connect to the embedded vPostgres database, use the psql command in the Windows command Prompt:
  1. To obtain the credentials to connect to the vCenters vPostgres database open the C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx\vcdb.properties file in a plain text editor.
Note: To view this file, administrator level permissions are required.
  1. Note the database name after the port in the URL string.
Example: url = jdbc:postgresql:/localhost:5432/VCDB
Note: VCDB is the database name in this example.
  1. Note the username in the string username = username.
Example: username = vc
Note: vc is the username in this example.
  1. Note the password in the string password = password.
Example: password = pXrE+82C@Mmn3+P1
Note: pXrE+82C@Mmn3+P1 is the password in this example.
  1. Click Start > Run type in cmd and press Enter.
  2. Change to the C:\Program Files\VMware\vCenter Server\vPostgres\bin\ directory.
Note: The drive letter may vary based on installation options.
  1. Connect to the postgres database by running the psql command:
psql -U username database_name

Note: Replace username with the username noted in steps 3, and database_name with the database name noted in step 2.
Example: psql -U vc VCDB
  1. Enter the password found in step 4 when prompted.
  2. To verify connectivity to the database run the following command:
\c database_name

Note: Replace database_name with the database name found in step 2.
Example: \c VCDB
You are now connected to database "VCDB" as user "vc"
  1. To exit the database type \q and press Enter.


Additional Information

Windows 環境で、vCenter Server 6.0 の組み込み vPostgres データベースに接続する方法
在安装了 Windows 的 vCenter Server 6.0 中连接到嵌入式 vPostgres 数据库
Conectando-se ao banco de dados vPostgres incorporado a um vCenter Server 6.0 instalado no Windows
Conexión a la base de datos vPostgres integrada en un servidor vCenter Server 6.0 instalado en Windows

Powered by Wolken Software