7.1 Postgres Administration - postgresql.conf

Published: 14 January 2023
on channel: SQL Depository

1,575

This module will discuss the config files of postgresql. This module is divided in to multiple videos.

The first part of module one will cover the main config file of postgres , which is postgresql.conf

#Commands and queries
#Check data and config file location
ps -ef|grep postgresql

#edit postgresql.conf
nano /etc/postgresql/15/main/postgresql.conf

#check shared buffers setting in postgres instance
show shared_buffers;

#check work memory buffers setting in postgres instance
show work_mem;

#check shared buffers modified value and applied status
select * from pg_file_settings where name='shared_buffers';

#check work mem buffers modified value and applied status
select * from pg_file_settings where name='work_mem';

On this page of the site you can watch the video online 7.1 Postgres Administration - postgresql.conf with a duration of online in good quality, which was uploaded by the user SQL Depository 14 January 2023, share the link with friends and acquaintances, this video has already been watched 1,575 times on youtube and it was liked by 17 viewers. Enjoy your viewing!