This assumes that sidekiq.service
is located in <rails root>/lib/services/sidekiq.service
WITH table_opts AS ( | |
SELECT | |
c.oid, c.relname, c.relfrozenxid, c.relminmxid, n.nspname, array_to_string(c.reloptions, '') AS relopts | |
FROM pg_class c | |
INNER JOIN pg_namespace n ON c.relnamespace = n.oid | |
WHERE c.relkind IN ('r', 't') AND n.nspname NOT IN ('pg_catalog', 'information_schema') AND n.nspname !~ '^pg_temp' | |
), | |
vacuum_settings AS ( | |
SELECT | |
oid, relname, nspname, relfrozenxid, relminmxid, |
FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.
- By Edmond Lau
- Highly Recommended 👍
- http://www.theeffectiveengineer.com/
# Fixex the error 'Failed: restore error: listDB.lists: error creating collection \ | |
# listDB.lists: error running create command: exception: specify size: when capped is true' | |
# | |
# Credits: Juan Pablo Nogueira, https://ar.linkedin.com/in/juan-pablo-nogueira-30645514/en | |
grep -rl ', "capped" : { "$undefined" : true }, "size" : { "$undefined" : true }' \ | |
/path/to/DB/to/be/restored/* | xargs sed -i 's/, "capped" : { "$undefined" : true }, \ | |
"size" : { "$undefined" : true }//g' | |
This procedure results in a computer that runs both Mac OS X and Ubuntu in a dual-boot configuration, each operating system using full (whole) disk encryption, and with the Ubuntu root file system stored on a ZFS pool encrypted using LUKS. The specific hardware and software versions used to document this procedure are:
- MacBookPro8,2
The existing docs when attempting to install CoreOS on Hetzner are a bit incomplete. This caused a bit of frustration for me so I am putting this doc together in hopes that it will help someone else.
After ordering your server you will need to log into the Hetzner server console
The easiest way to get the ClamAV package is using Homebrew
$ brew install clamav
Before trying to start the clamd
process, you'll need a copy of the ClamAV databases.
Create a freshclam.conf
file and configure as so
about:config settings to harden the Firefox browser. Privacy and performance enhancements.
To change these settings type 'about:config' in the url bar.
Then search the setting you would like to change and modify the value. Some settings may break certain websites from functioning and
rendering normally. Some settings may also make firefox unstable.
I am not liable for any damages/loss of data.
Not all these changes are necessary and will be dependent upon your usage and hardware. Do some research on settings if you don't understand what they do. These settings are best combined with your standard privacy extensions
(HTTPS Everywhere No longer required: Enable HTTPS-Only Mode, NoScript/Request Policy, uBlock origin, agent spoofing, Privacy Badger etc), and all plugins set to "Ask To Activate".
#!/bin/bash | |
# Script that detects arrival,presence,departure of iPhone on local network | |
# Requires arp-scan tool | |
# Written by Zbyszek Żółkiewski, please visit: http://blog.onefellow.com | |
# Install: | |
# - copy ip_scan.sh to /usr/local/bin/ | |
# - chmod ugo+x /usr/local/bin/ip_scan.sh | |
# - change 'ip_iphone' variable to point you your iPhone IP | |
# - option: insert your boxcar_id otherwise comment-out boxcar_send function in action_after_grace | |
# - put into cron: echo "*/1 * * * * root /usr/local/bin/ip_scan.sh" > /etc/cron.d/iphone_scan , or whatever user you want |