Postgresql – What are current values in PG admin configuration editor for postgresql.conf configurationpgadminpostgresql I am tuning a postgresql.conf file and here is what is shown in PG admin configuration editor What does the current value corresponds to? For the shared buffers (red line), what is the value there? Best Answer Current value is what the currently active database is using. many of those settings require the database to be restarted (or reboot) before they take effect. Related SolutionsPostgresql – How to set the external editor for PostgreSQL’s psql client Contrary to my comment above (which was the result of insufficient testing), you should put a line into .bashrc (or any similar place): export PSQL_EDITOR="/Users/username/bin/mate" In psql coming with PostgreSQL 9.2, there is a \setenv command, it is supposed to work from .psqlrc as well. (Credits to Pedro Romano.) Postgresql – Can’t start postgres server, SHMMAX too small This question has been asked many times. Try a search. Or Google. This chapter of the manual deals with it comprehensively. Related QuestionPostgresql – Mismatch between size computed from pg_buffercahce Vs shared_buffers in postgresqlSql-server – Optimum configuration for 4 SSD drivesMysql – What MySQL configuration options require more than editing the the.cnf file and restarting the serverPostgreSQL Configuration – Finding the Source of a Specific SettingQuery for All Postgres Configuration Parameters’ Current ValuesPostgresql – Why does PostgreSQL ignore auto_explain.log_analyze = 0 in is postgresql.conf file and how can I turn on auto_explain for all sessionsPostgresql – In postgresql.conf, does the order of the listed parameters matter
Best Answer
Current value is what the currently active database is using.
many of those settings require the database to be restarted (or reboot) before they take effect.