Skip to content

Instantly share code, notes, and snippets.

@vyspiansky

vyspiansky/postgres-commands.md

Created January 31, 2023 21:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vyspiansky/dc9538f3fb4a366bc244bb63bc116660 to your computer and use it in GitHub Desktop.
Save vyspiansky/dc9538f3fb4a366bc244bb63bc116660 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres: useful commands
Raw
postgres-commands.md

DB restart

postgres=# SELECT pg_reload_conf();
  pg_reload_conf
----------------
  t
(1 row)

Is SSL enabled?

postgres=# SHOW ssl;
  ssl
-----
  on
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment