Esxi og vCenter: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
=vcenter postgresql= | =vcenter postgresql= | ||
Disclaimer: describes vcenter 6.0 - it may vary for other versions ? | Disclaimer: describes vcenter 6.0.0 (b 3271482) - it may vary for other versions ? | ||
vcenter uses an embedded postgresql installation. Binaries are located in /opt/vmware/vpostgres/current/bin - data and config files are located in /storage/db/vpostgres/ | vcenter uses an embedded postgresql installation. Binaries are located in /opt/vmware/vpostgres/current/bin - data and config files are located in /storage/db/vpostgres/ | ||
| Line 6: | Line 6: | ||
On installation vCenter sets a number of config overrides in <datadir>/postgresql.conf.auto - pay attention to <code>work_mem</code> and <code>temp_buffers</code> - they might be set lower than postgresql default values (which is quite silly imho.) which will limit performance of postgresql - espesically when querying performance counters. | On installation vCenter sets a number of config overrides in <datadir>/postgresql.conf.auto - pay attention to <code>work_mem</code> and <code>temp_buffers</code> - they might be set lower than postgresql default values (which is quite silly imho.) which will limit performance of postgresql - espesically when querying performance counters. | ||
==launch psql== | |||
start psql client with <code>/opt/vmware/vpostgres/current/bin/psql -h localhost -U postgres</code> | start psql client with <code>/opt/vmware/vpostgres/current/bin/psql -h localhost -U postgres</code> | ||
Latest revision as of 20:09, 26 June 2017
vcenter postgresql
Disclaimer: describes vcenter 6.0.0 (b 3271482) - it may vary for other versions ?
vcenter uses an embedded postgresql installation. Binaries are located in /opt/vmware/vpostgres/current/bin - data and config files are located in /storage/db/vpostgres/
On installation vCenter sets a number of config overrides in <datadir>/postgresql.conf.auto - pay attention to work_mem and temp_buffers - they might be set lower than postgresql default values (which is quite silly imho.) which will limit performance of postgresql - espesically when querying performance counters.
launch psql
start psql client with /opt/vmware/vpostgres/current/bin/psql -h localhost -U postgres