Skip to content

Instantly share code, notes, and snippets.

View a1anw2's full-sized avatar

Alan Williamson a1anw2

View GitHub Profile
select
t1.datname AS db_name,
pg_size_pretty(pg_database_size(t1.datname)) as db_size
from
pg_database t1
order by
pg_database_size(t1.datname) desc;
@a1anw2
a1anw2 / gist:b90de95ff201e35581cd718d5812989a
Last active January 5, 2021 17:22
SOCKS setup on ubuntu
## Setup SSH keygen
sudo -s
Create the key
ssh-keygen
Then we need to add this to the authorized users in the local user
cat /root/.ssh/id_rsa.pub >> /home/localuser/.ssh/authorized_keys