...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...
...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;
There are different kind of memory measurement metrics in Linux. These are the differences: Code Name Description vsz virtual memory...
What is netfilter's Connection Tracking system? The connection tracking system often referenced as nf_conntrack is part of the...
How can I configure virtual IP's? There are two parameter to set up virtual ips in Keepalived: virtual_ipaddress...
...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...
Ever needed to migrate data between Redis instances? Give RIOT - Redis Input/Output Tools a try. It supports migration to different...
...either build a ES cluster or you disable the replicas. Building a cluster is beyond the scope of this card, but we can have a look how we can disable...
...localhost:9200/_cat/shards?pretty' | grep UNASSIGNED If it's a replica (r in the column befor the UNASSIGNED) and you are on a single node elasticsearch you need to disable replicas...
...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...
When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
...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...
...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...
If you want someone to be able to access your rails console, but don't want them to be able...
...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 use third party APT sources you might end up with unmaintained packages after removing the external source or...
...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.
When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.
The owner of a scheduled CI/CD pipeline in GitLab will always be notified if the pipeline fails. Follow these steps...
Important wkhtmltopdf is deprecated and shouldn't be used anymore. Please consider switching to another tool We can install wkhtmltopdf...
Hint This applies only to distributions based on Debian. Requirement You need to setup the PostgreSQL Apt Repository first.
When using tmux, selecting and copying multiple lines of text can be a hassle, especially when using splits (highlighting lines...
Investigate why mails are frozen The exim documentation says: Freezing occurs when a bounce message encounters a permanent failure because...