PostgreSQL基础 psql 查看端口号

CentOS 7.6.1810
postgresql 14.4

psql 查看端口号

postgres=# show port;
-[ RECORD 1 ]
port | 5432

postgres=# select current_setting('port');
-[ RECORD 1 ]---+-----
current_setting | 5432

postgres=# select * from pg_settings where name='port';
-[ RECORD 1 ]---+-----------------------------------------------------
name            | port
setting         | 5432
unit            | 
category        | Connections and Authentication / Connection Settings
short_desc      | Sets the TCP port the server listens on.
extra_desc      | 
context         | postmaster
vartype         | integer
source          | default
min_val         | 1
max_val         | 65535
enumvals        | 
boot_val        | 5432
reset_val       | 5432
sourcefile      | 
sourceline      | 
pending_restart | f

学习资料

• postgresql
• download-postgresql
• docs-postgresql
• db-engines
• 墨天轮社区

欢迎各位同学一起来交流学习心得！