If you’re here, you’re probably trying to get into the infrastructure world. First, I’m so sorry. Second, the links here are my tried-and-true resources to navigate the fundamentals in this jungle. Hopefully, they’ll make a difference for you too.
Sometimes, we want to avoid going through the trouble of creating YAML files for resources, checking their syntax, and versioning everything. Sometimes, we only want something up and running for a POC, a quick test, or a debugging session. For those moments, these commands can help.
iptables is a Linux firewall tool that manages packet routing and can block or allow traffic based on rules like a packet’s origin or destination.
psql -h $POSTGRES_HOST -U $POSTGRES_USER $POSTGRES_DB
\du # list all users
\l # list databases
\c # select a database
\d # list tables
\d+ <table_name> # describe table
\dx # list installed extensions
SELECT * FROM pg_available_extensions; # list extensions available on the server
CREATE EXTENSION IF NOT EXISTS <ext_name>; # install an extension
ALTER EXTENSION <ext_name> UPDATE TO 'new_version'; # upgrade an extension