til
til copied to clipboard
xluffy
You only feel happy when you know what you doing
- LogBucket, storage pricing: **$0.50/GiB** - GCS thì giá sẽ phức tạp hơn: - Standard storage: **$0.02/GB** (với Region) hoặc **$0.022/GB** (dual region) -> tức là về mặt storage, LogBucket...
Sometimes, you want to connect via URI `postgres` user, same with switching to `postgres` user from the command line ``` postgres:///?host=/var/run/postgresql/&sslmode=disable&port=5433 postgresql:///?host=/var/run/postgresql/&sslmode=disable&port=5433 ```
``` \COPY (SELECT * FROM items LIMIT 10) TO '/tmp/items.csv' WITH (FORMAT CSV, HEADER, FORCE_QUOTE *); ```
> One of these nifty features that I want to share about is the`auth_user` and`auth_query` combo that serves as an alternative to the default authentication process that uses `userlist.txt `....
``` > select rolname, rolpassword from pg_authid ``` We don't need to generate hash password for Pgbouncer ``` # How to create an MD5 password for pgbouncer # Linux: #...
https://martinheinz.dev/blog/105 
- pg_squeeze: https://github.com/cybertec-postgresql/pg_squeeze or https://reorg.github.io/pg_repack/ > PostgreSQL extension that removes unused space from a table and optionally sorts tuples according to particular index (as if [CLUSTER](https://www.postgresql.org/docs/13/static/sql-cluster.html) command was executed concurrently...
**JSON** PostgreSQL giới thiệu kiểu dữ liệu `json` kể từ Postgres 9.2, mục tiêu là làm đa dạng hệ sinh thái, cung cấp thêm tính năng làm đối trọng với...
``` /usr/bin/find /data/backups/ -mtime +7 -exec rm -rvf '{}' + ``` or ``` /usr/bin/find /data/backups/ -mtime +7 -exec rm -rvf '{}' \ ``` The `+` at the end will result...