...dumps can be created in multiple formats (see option -F in pg_dump documentation. Benefits of the custom format are more configurable restores (for e.g. you can omit setting permissions...
...speeds up restores). The custom dump is compressed by default too. To get a better idea check the parameters in the mentioned documentation. You can use a custom format dump...
It happens from time to time that a job in a GitLab pipeline fails. Sometimes, however, the error message is...
If you want to perform a failover on another haproxy backend server this is the way you should do it...
How can I configure virtual IP's? There are two parameter to set up virtual ips in Keepalived: virtual_ipaddress...
...the number and last point in time when autovacuum and autoanalyze happened for tables belonging to the currently connected database. SELECT relation::regclass, * FROM pg_locks WHERE not granted;
...already_read" : 0, "request_body_fully_read" : true, "request_body_type" : "NO_BODY", "response_begun" : false, "session" : { "gupid" : "18asd3ed-U4FSeggT0O", "pid" : 4273 }, "last_data_send_time" : null, tells me, that...
Ever needed to migrate data between Redis instances? Give RIOT - Redis Input/Output Tools a try. It supports migration to different...
...to determine if a service can be restarted or not. To manipulate the default behaviour, the package policy-rcd-declarative-allow-all or policy-rcd-declarative-deny-all can be...
...of your workload, a fixed-CPU instance from the M or C series offers better performance for a lower price. General T instances have a Baseline utilization per vCPU.
...Every burstable instance has a CPU utilization break-even when a fixed-CPU instance becomes cheaper. The fixed CPU instances are not only cheaper at that point, they also offer...
Because systemd is the greatest thing ever it's not enough to stop the libvirt service. You need to disable...
If a users password for https://monitor.makandra.de/ is unknown one can set it like this: sudo python /opt/graphite/webapp/graphite/manage.py changepassword ${USERNAME...
...like these before applying them to production. When entering these rules in the screen behind the Edit Test Rules button in the AWS console and testing it, the results section...
...use version 5.2.0 or newer to ensure you can deploy via Capistrano. It's best to use the latest version, as there were multiple issues between 5.2.0 and 7.3.0.
If you use third party APT sources you might end up with unmaintained packages after removing the external source or...
When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
Hint This applies only to distributions based on Debian. Requirement You need to setup the PostgreSQL Apt Repository first.
If you want someone to be able to access your rails console, but don't want them to be able...
Important wkhtmltopdf is deprecated and shouldn't be used anymore. Please consider switching to another tool We can install wkhtmltopdf...
JSON Web Tokens are often times used for authentication delegation from one system to another. They can be decoded for...
...the puppetdb_query feature. This can result in more complex code but has several benefits: you can use more complex puppetdb queries to get the resources you want than with...
If you need to pre-generate a scram-sha256 password hash for use with postgres, e.g. for using it with...
When setting up cronjobs, commands somtimes output something every time. If these commands don't support limiting their output to...
When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.
When using tmux, selecting and copying multiple lines of text can be a hassle, especially when using splits (highlighting lines...