Author: jpuyy
-
postgresql
postgresql service local https://hub.docker.com/_/postgres docker run –name postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres docker exec -it postgres /bin/bash test connection pg_isready -d -h -p -U pg_isready -h 127.0.0.1 -p 5432 -U root apt install postgresql-client-13 find configuration file psql -U postgres -c ‘SHOW config_file’ print time psql -U postgres -c “select (to_char(CURRENT_TIMESTAMP ,’yyyy-MM-dd HH24:MI’)||’:00′)::timestamp”
-
git 根据条件计算中间 commit 数量
https://stackoverflow.com/a/11657647/3672812 在 feature 分支下 git rev-list –count HEAD ^master 13
-
kafka-console-consumer 对 topic 测试
To listen for messages on a topic: kafka-console-consumer –bootstrap-server kafka:9092 –topic test1 –from-beginning To stop the listener session above press: Ctrl+C To start an interactive message producer session: kafka-console-producer –broker-list kafka-headless:9092 –topic test1 To create a message in the above session, simply type the message and press “enter” To end the producer session try: Ctrl+C…
-
mktemp 生成临时文件或目录
Usage: mktemp [OPTION]… [TEMPLATE] Create a temporary file or directory, safely, and print its name. TEMPLATE must contain at least 3 consecutive ‘X’s in last component. If TEMPLATE is not specified, use tmp.XXXXXXXXXX, and –tmpdir is implied. Files are created u+rw, and directories u+rwx, minus umask restrictions. -d, –directory create a directory, not a file…