blob: 694aa4e57657f5d727369928db9f51f5716629aa (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
#+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
|
