diff options
Diffstat (limited to 'databases/passwords/postgres')
| -rw-r--r-- | databases/passwords/postgres/README.org | 31 | ||||
| -rw-r--r-- | databases/passwords/postgres/passwords.sql | 18 |
2 files changed, 0 insertions, 49 deletions
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 |