From 95bf612c338dec8235e89ca6a1d9e5e8cad3f997 Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Tue, 6 May 2025 21:31:46 -0500 Subject: reorganize db dir (#6) --- databases/passwords/postgres/README.org | 31 ------------------------------ databases/passwords/postgres/passwords.sql | 18 ----------------- 2 files changed, 49 deletions(-) delete mode 100644 databases/passwords/postgres/README.org delete mode 100644 databases/passwords/postgres/passwords.sql (limited to 'databases/passwords/postgres') diff --git a/databases/passwords/postgres/README.org b/databases/passwords/postgres/README.org deleted file mode 100644 index 694aa4e..0000000 --- a/databases/passwords/postgres/README.org +++ /dev/null @@ -1,31 +0,0 @@ -#+title: Postgres Passwords - -* =passwords.sql= - -#+begin_src sql -SELECT * -FROM pg_settings -WHERE name LIKE 'password_%'; -#+end_src - -#+begin_src -| name | setting | unit | category | short_desc | extra_desc | context | vartype | source | min_val | max_val | enumvals | boot_val | reset_val | sourcefile | sourceline | pending_restart | -|---------------------+---------------+------+-------------------------------------------------+-------------------------------------------------+------------+---------+---------+---------+---------+---------+---------------------+---------------+---------------+------------+------------+-----------------| -| password_encryption | scram-sha-256 | | Connections and Authentication / Authentication | Chooses the algorithm for encrypting passwords. | | user | enum | default | | | {md5,scram-sha-256} | scram-sha-256 | scram-sha-256 | | | false | -#+end_src - -#+begin_src sql -SELECT - usename AS user_name, - passwd AS password, - valuntil AS valid_until, - useconfig AS user_config -FROM pg_shadow; -#+end_src - -#+begin_src -| user_name | password | valid_until | user_config | -|-----------+---------------------------------------------------------------------------------------------------------------------------------------+------------------------+-------------| -| cmc | | | | -| testuser | SCRAM-SHA-256$4096:+NSpEU+8afhJ4BUTkzdKeg==$FGIRcTWr89b42qkLUl4Ntfp4RUpoc3GIpLHqJl/fWZE=:o1UM8YiEj5SLV5l/geMuqXMRi6onWazryn/l+LXYMxU= | 2025-12-31 00:00:00-06 | | -#+end_src diff --git a/databases/passwords/postgres/passwords.sql b/databases/passwords/postgres/passwords.sql deleted file mode 100644 index cb81cd6..0000000 --- a/databases/passwords/postgres/passwords.sql +++ /dev/null @@ -1,18 +0,0 @@ --- References: --- : https://www.postgresql.org/docs/current/view-pg-shadow.html --- : https://www.postgresql.org/docs/current/auth-password.html --- : https://www.postgresql.org/docs/current/auth-password.html#AUTH-PASSWORD-ENCRYPTION --- : https://www.postgresql.org/docs/current/runtime-config.html - --- Defined password configuration -SELECT * -FROM pg_settings -WHERE name LIKE 'password_%'; - --- Users and their password configurations -SELECT - usename AS user_name, - passwd AS password, - valuntil AS valid_until, - useconfig AS user_config -FROM pg_shadow; \ No newline at end of file -- cgit v1.2.3-70-g09d2