Skip to content

Instantly share code, notes, and snippets.

View eveland's full-sized avatar

Eve eveland

1 follower · 0 following
  • Maryland
View GitHub Profile
@eveland
eveland / self-signed-certificate-key-ca.md
Last active March 25, 2020 14:10 — forked from fntlnz/self-signed-certificate-with-custom-ca.md
Self Signed Certificate, Key and CA

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -out rootCA.key 4096
@eveland
eveland / postgres-cheatsheet.md
Created December 12, 2019 17:12 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)