Installing Postgresql 13 - Documentation for Bmc Client Management 21.02
Bcm Recommends Installing Postgresql Version 13 Which Faster Than the Older Versions. Postgresql 13 Can Be Downloaded At. Bmc Recommends Installing Postgresql...
BCM recommends installing PostgreSQL version 13 which faster than the older versions. PostgreSQL 13 can be downloaded at . BMC recommends installing PostgreSQL 13 on Linux. Some distributions such as Red-Hat Family, Debian, Ubuntu, Suze and OpenSuze are available.
Go to PGTune and provide basic information about the hardware configuration.
Must Read
Select 13 from the DB version list.
Select Linux/OS X from the OS Type list.
Select Mixed type of applications from the DB Type list.
For Total Memory (RAM) and Number of CPUs see Hardware requirements.
For the recommendations, see PostgreSQL recommendations.
Select 100 from the Number of Connections list.
Select type of hard drive which PostgreSQL use as storage from the Data Storage list.
Click Generate and go to the ALTER SYSTEM tab. The configuration for PostgreSQL is calculated based on the provided hardware configuration.
Click Copy configuration.
Connect to the PostgreSQL database.
sudo -u postgresql psql
postgres=#
paste the copy configuration
ALTER SYSTEM SET max_connections = '100';
ALTER SYSTEM SET shared_buffers = '4GB';
ALTER SYSTEM SET effective_cache_size = '12GB';
ALTER SYSTEM SET maintenance_work_mem = '1GB';
ALTER SYSTEM SET checkpoint_completion_target = '0.9';
ALTER SYSTEM SET wal_buffers = '16MB';
ALTER SYSTEM SET default_statistics_target = '100';
ALTER SYSTEM SET random_page_cost = '4';
ALTER SYSTEM SET effective_io_concurrency = '2';
ALTER SYSTEM SET work_mem = '5242kB';
ALTER SYSTEM SET min_wal_size = '1GB';
ALTER SYSTEM SET max_wal_size = '4GB';
ALTER SYSTEM SET max_worker_processes = '8';
ALTER SYSTEM SET max_parallel_workers_per_gather = '4';
ALTER SYSTEM SET max_parallel_workers = '8';
ALTER SYSTEM SET max_parallel_maintenance_workers = '4';Add the following settings to perform autovacuum.
ALTER SYSTEM SET bgwriter_lru_maxpages = '1000';
ALTER SYSTEM SET bgwriter_lru_multiplier = '4.0';
ALTER SYSTEM SET random_page_cost = '2.0';
ALTER SYSTEM SET cpu_tuple_cost = '0.03';
ALTER SYSTEM SET log_autovacuum_min_duration = '0';
ALTER SYSTEM SET autovacuum_max_workers = '5';
ALTER SYSTEM SET autovacuum_vacuum_cost_delay = '10ms'; Enter # \q to quit the PostgreSQL database.
Restart the database.
sudo systemctl restart postgresql-13To check whether these settings are running, execute the following command.
sudo -u postgresql psql
postgres=# show shared_buffers;
shared_buffers
----------------
4GBThe value of ‘shared_buffer’ varies depending on the configuration copied in step 9.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
