When querying large tables you might see an output like this, which is not readable at all:ĭepending on the situation you can either disable unaligned output or activate expanded output. ORDER BY pg_total_relation_size(C.oid) DESC WHERE nspname NOT IN ('pg_catalog', 'information_schema') LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) Pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
Use the following SQL command to list top 10 tables by their size: SELECT nspname || '.' || relname AS "table", The VCDB has more than 1000 tables, so it might become difficult to identify which tables are the biggest. Use \l+ to list all databases with their size: All commands start with a backslash (\) to differentiate from standard SQL Queries. While in the PSQL Shell you should make yourself familiar with a couple of basic commands.
Psql (PostgreSQL) 10.5 PSQL Basic Commands In vSphere 7.0 for example, the OS binaries are at version 10.5 while the Postgres server is running 11.6: # /opt/vmware/vpostgres/current/bin/psql -version The reason is that VMware uses a more recent version than it is provided by the OS. When connecting, make sure that you use the psql binaries located in /opt/vmware/vpostgres/current/bin/ and not just the psql command. # /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB It is convenient to also use the -d option to directly connect to the VCDB instance. The simplest way to connect to the databases is by using the "postgres" user, which has no password. Just enter "shell" to enter the fully-featured bash shell. When first connecting to the appliance, you see the "Appliance Shell".
To connect to the database, you have to enable SSH for the vCenter Server, login as root, and launch the bash shell. Consider working with VMware Support if you have problems in a critical production environment. Make sure that you know what you are doing and double-check that you have a working backup or snapshots of the vCenter Server Appliance.
#DELTA ORCAVIEW PG MODIFIED NO CHANGE HOW TO#
This article explains how to connect and work with the embedded vPostgres Database of a vCenter Server Appliance version 6.5, 6.7, and 7.0.Ĭaution: Working with the database can cause issues with the vCenter Service.
0 kommentar(er)
