TIL, 2017-08-22
select * from pg_stat_activity where datname = 'mydatabasename';
to view current connections in the Postgres database. Thenpkill
all connections.- Read later: Reference
- You can’t restore just a single database from a snapshot, you restore an entire snapshot.
- Problem with reconcile, the
where
also counts nils (Christ.) shoulda-matchers
breaks down when conditionals appear.- If you cannot connect to somewhere maybe your Security Group sucks.
be cap staging thin:stop
to stop Rails first on staging.- AWS has a CLI.
vim /var/log/auth.log
: Shows SSH access attempts.auditd
: A kernel level way to track whatever you need to audit.- Reversing an array: cool.