Last entries
-
Keep Your postgres|postgresql Stable — Vacuum - [s]
-
postgres|postgresql > Understanding and Monitoring pg_stat_user_indexes - [s]
-
postgresPostgreSQL: Documentation: 17: ANALYZE - [s]
-
Installing local plugin via jenkins-cli - Stack Overflow - [s]
-
git|github > 'credential-manager' is not a git command - [s]
# Mac|MacOS /System/Volumes/Data/Users/$USER/.gitconfig
-
git|github - How to re-authorize the OAuth Application 'Git Credential Manager' - [s]
gh auth login
-
ubuntu|apt > apt-get update log /var/log/apt/term.log - [s]
-
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
-
postgres|jsonb > Update JSON Data in PostgreSQL - [s]
UPDATE blob_store_configuration set attributes = jsonb_set(attributes, '{s3, accessKeyId}','"XXXXXXXXXXXXXXXXXXX"') where name = 's3-test';
-
postgres|postgresql|flyway > check|list status of advisory lock - [s]
-
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
-
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;
-
Android Developers Blog: Quick introduction to Large Language Models for Android - [s]