tar c -I"zstd -T0" -f temp.tar.zst temp
tar -x --zstd -f temp.tar.zst -C temp
zstd
Leave a reply
postgres show process list
SELECT user, pid, client_addr, query, query_start, NOW() - query_start AS elapsed
FROM pg_stat_activity
WHERE query != ''
-- AND EXTRACT(EPOCH FROM (NOW() - query_start)) > 1
ORDER BY elapsed DESC;
psql list database size
psql:
SELECT pg_size_pretty(pg_database_size(pg_database.datname)) AS size_in_mb,
pg_database.datname as database_name
FROM pg_database ORDER BY pg_database_size(pg_database.datname) DESC;
With index use: pg_total_relation_size, insead of pg_database_size
size_in_mb | database_name
------------+---------------
7571 kB | template1
7499 kB | postgres
7345 kB | template0
(3 rows)
kibana find filter grok parse error
tags:_grokparsefailure
memcached show connections
echo stats | nc 127.0.0.1 11211 | grep accept
STAT accepting_conns 1
or
strace -e read,write -fp $(pgrep memcached)
ansible add user sudo and upload SSH public key
---
- hosts: 127.0.0.1
user: root
tasks:
- group: name=mygroup state=present
- name: Add user to mygroup
user: name=myuser groups=mygroup append=yes
- name: Setup authorized key
authorized_key:
user: myuser
state: present
key: "{{ lookup('file', 'myuser_key.pub') }}"
- name: Allow mygroup group to have passwordless sudo
lineinfile:
dest: /etc/sudoers
state: present
regexp: '^%mygroup'
line: '%mygroup ALL=(ALL) NOPASSWD: ALL
ansible remove group from user
---
- hosts: 127.0.0.1
user: root
tasks:
- name: Remove myuser from mygoup
become: true
command: "gpasswd -d myuser mygroup"
register: command_result
changed_when: "not 'is not a member of' in command_result.stderr"
failed_when: "'does not exist in /etc/group' in command_result.stderr"
ssh no hostkeys available
ssh-keygen -A
service ssh --full-restart
mcedit f10 exit
Esc + 0 to simulate F10. Also works with 1-9 for F1-F9
sed change php settings
sed --debug -i 's/^.*max_input_vars\s*=.*/max_input_vars = 100000/g' /etc/php/*/*/php.ini | grep MATCHED -A1
/etc/ansible missing
apt install ansible
mkdir /etc/ansible ; cd $_
ansible-config init --disabled > ansible.cfg
ansible-config --version
postgres show process list
\c postgres
SELECT *
FROM pg_stat_activity
WHERE datname = 'mydb';
Kill connections to database if you want:
SELECT
pg_terminate_backend (pid)
FROM
pg_stat_activity
WHERE
datname = 'mydb';
postgres rename database
su - postgres
psql
ALTER DATABASE oldb RENAME TO newdb;
postgresql import gz
su - postgres
gunzip < /tmp/db.sql.gz | psql mydb
ubuntu 24 install postgresql 17
apt install postgresql-common
/usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
apt update && apt upgrade
apt install postgresql-17
pg_ctlcluster 17 main start
pg_ctlcluster 17 main status
pg_ctl: server is running (PID: 1028)
/usr/lib/postgresql/17/bin/postgres "-D" "/var/lib/postgresql/17/main" "-c" "config_file=/etc/postgresql/17/main/postgresql.conf"
vim /etc/postgresql/17/main/pg_hba.conf
host all all 0.0.0.0/0 md5
host all all ::/0 md5
vim /etc/postgresql/17/main/postgresql.conf
listen_addresses = '*'
pg_ctlcluster 17 main restart