You can use pg_repack to do a VACUUM FULL without holding an exclusive lock during processing. There is still...
Attention This is an edge-case. You probably don't want to mix different database dumps. It also requires that...
To delete a specific redis-DB you need to use the FLUSHDB-command in combination with the SELECT-command. For...
We had a strange behaviour on one of our mariadb-servers: Everyday at around midnight we saw that the root...
When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.
The Oracle mysql client has an odd behavior if your server uses latin1 as default character-set-server. Command
If your postgres database is only accessible from inside a kubernetes cluster, e.g. if it's configured in AWS RDS...
Here's a one-liner to view base64 encoded secrets in kubernetes. Make sure you have jq installed.
How can I configure virtual IP's? There are two parameter to set up virtual ips in Keepalived: virtual_ipaddress...
What is netfilter's Connection Tracking system? The connection tracking system often referenced as nf_conntrack is part of the...
If you have a very large datadir in MariaDB and you want to transfer the data to another host (e.g...
If you're about to handle X509 certificates and don't want to remember/google a handful of openssl commands you...
If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL...
If freshclam updates are failing even though the update servers are available and you find error messages like the following...
If one etcd node is no longer a member of the remaining etcd cluster or fails to connect you need...
This card is just about creating simple PostgreSQL dumps. This is no instruction for a backup strategy nor a guide...
Hint This applies only to distributions based on Debian. Requirement You need to setup the PostgreSQL Apt Repository first.
on the bash (issued as postgres user) Start/Stop/Restart PostgreSQL pg_ctl -D $configdir start|stop|restart Start/Stop/Restart the corresponding PostgreSQL...
If you want to perform a failover on another haproxy backend server this is the way you should do it...
Best results in other decks
When you want to filter records in a model where a string column roughly matches a given term, you can...
You can check the maximum client Redis database size in Sidekiq with this command. Sidekiq.redis { |redis| puts redis.info.fetch('maxmemory_human...