📋Steps in this guide1/1

Find postgres configuration values

1 . Get Config values from psql prompt.

postgresql configurationintermediate

by PostgreSQL

14 views

Find postgres configuration values

1 . Get Config values from psql prompt. 2. Alternatively you can check postgresql.conf file

Code/Command (click line numbers to comment):

postgres=#
select * from pg_settings;
\x
postgres=#
select * from pg_settings where name='port';
postgres=#
show config_file;
config_file
---------------------------------
/pgdata/data/postgresql.conf
(1 row)
cat /pgdata/data/postgresql.conf

Comments (0)

Please to add comments

No comments yet. Be the first to comment!