| BML-S | Help Login

Last entries

    20241103.0930
  1. Keep Your postgres|postgresql Stable — Vacuum - [s]

  2. 20241103.0927
  3. postgres|postgresql > Understanding and Monitoring pg_stat_user_indexes - [s]

  4. 20241029.1130
  5. postgresPostgreSQL: Documentation: 17: ANALYZE - [s]

  6. 20241029.1017
  7. Installing local plugin via jenkins-cli - Stack Overflow - [s]

  8. 20241028.0813
  9. git|github > 'credential-manager' is not a git command - [s]

    # Mac|MacOS /System/Volumes/Data/Users/$USER/.gitconfig

  10. 20241028.0803
  11. git|github - How to re-authorize the OAuth Application 'Git Credential Manager' - [s]

    gh auth login

  12. 20241024.1507
  13. ubuntu|apt > apt-get update log /var/log/apt/term.log - [s]

  14. 20241024.1032
  15. postgres|postgresql > all permissions|privileges - [s]

    ---- nxrm=# \dn+ List of schemas Name | Owner | Access privileges | Description --------+-------+-------------------+------------- public | nexus | nexus=UC/nexus | (1 row) nxrm=# \dp mytable Access privileges Schema | Name | Type | Access privileges | Column access privileges --------+---------+-------+-----------------------+-------------------------- public | mytable | table | miriam=arwdDxt/miriam | col1: : =r/miriam : miriam_rw=rw/miriam : admin=arw/miriam (1 row) ---- rolename=xxxx -- privileges granted to a role =xxxx -- privileges granted to PUBLIC r -- SELECT ("read") w -- UPDATE ("write") a -- INSERT ("append") d -- DELETE D -- TRUNCATE x -- REFERENCES t -- TRIGGER X -- EXECUTE U -- USAGE C -- CREATE c -- CONNECT T -- TEMPORARY arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects) * -- grant option for preceding privilege /yyyy -- role that granted this privilege

  16. 20241021.1402
  17. postgres|jsonb > Update JSON Data in PostgreSQL - [s]

    UPDATE blob_store_configuration set attributes = jsonb_set(attributes, '{s3, accessKeyId}','"XXXXXXXXXXXXXXXXXXX"') where name = 's3-test';

  18. 20241016.1448
  19. postgres|postgresql|flyway > check|list status of advisory lock - [s]

  20. 20241016.1245
  21. postgres|postgresql > How to Resolve pg_wal Running Out of Disk Space - [s]

    $ pg_controldata -D /opt/homebrew/var/postgresql@14 pg_control version number: 1300 Catalog version number: 202107181 Database system identifier: 7156816885991412919 Database cluster state: in production pg_control last modified: Tue 15 Oct 18:01:00 2024 Latest checkpoint location: 97/5D384BB0 Latest checkpoint's REDO location: 97/5D384B78 Latest checkpoint's REDO WAL file: 00000001000000970000005D <<< Latest checkpoint's TimeLineID: 1 ... Time of latest checkpoint: Tue 15 Oct 18:01:00 2024 ... # Simulating/testing WAL file cleanup $ cd "/opt/homebrew/var/postgresql@14" $ ls -l ./pg_wal/00000001000000970000005D -rw------- 1 hosako admin 16777216 15 Oct 18:01 ./pg_wal/00000001000000970000005D $ pg_archivecleanup -n -d ./pg_wal/ 00000001000000970000005D pg_archivecleanup: keeping WAL file "./pg_wal//00000001000000970000005D" and later

  22. 20241016.1232
  23. The Power of JSONB in PostgreSQL. PostgreSQL is a powerful relational… | by Mohammad Roshandelpoor | Medium - [s]

    -> : Extracts a JSON element by key or array index. ->> : Extracts a JSON element as text. #> : Extracts a JSON sub-object at a specified path. #>> : Extracts a JSON sub-object as text. @> : Checks if a JSON document contains another JSON document. <@ : Checks if a JSON document is contained within another JSON document. jsonb_array_elements(): Expands a JSON array into a set of rows. jsonb_each(): Expands a JSON object into key-value pairs. ---- -- Access the first element in the 'ids' array within 'params' SELECT params->'ids'->0 FROM events; -- Check if the employee has a skill in "Sales" SELECT * FROM employees WHERE employee_data->'skills' @> '["Sales"]'; ---- -- Append JSON strings in the end of another JSON UPDATE promotion_banners SET items = items || '{"status": 1}'::jsonb WHERE id = 2;

  24. 20241016.1219
  25. Android Developers Blog: Quick introduction to Large Language Models for Android - [s]

[s] public (13)