Andrew Mercer

▶ Docs
- ▶ Linux
  - ▶ Linux core subsystem
    - ▶ Bash and builtins
      - Bash one-liners
      - Readme
    - ▶ Coreutils
      - or
    - ▶ Util Linux
      - etc.
      - ▶ Ionice
        
        Readme
      - ▶ Logger
        
        Test inserting log messages into logging stream
      - ▶ Rename
        
        Rename files
  - ▶ Linux desktop
    - Linux fun stuff
  - ▶ Linux distros
    - ▶ AlmaLinux
      - Install Almalinux
    - ▶ Android
      - Backup Android Phone
    - ▶ Arch
    - ▶ CentOS
    - ▶ Fedora
      - Upgrading Fedora
    - ▶ Gentoo
    - ▶ Linux from scratch (LFS)
    - ▶ OpenSuse
    - ▶ OpenWrt
    - ▶ Oracle Linux
    - ▶ Red Hat Enterprise Linux (RHEL)
      - ▶ Red Hat Satellite
        
        ▶ Hammer
    - ▶ Rocky Linux
    - ▶ Scientific Linux
    - ▶ Ubuntu
      - Install Ubuntu Server
    - ▶ Windows Subsystem for Linux Wsl
      - Install WSL
  - ▶ Linux filesystems
  - ▶ Linux high availability
    - ▶ Corosync
  - ▶ Linux networking
  - ▶ Linux performance & monitoring
  - ▶ Linux tools
    - Fdisk
    - History
- ▶ Cloud
  - ▶ Amazon Web Services (AWS)
    - ▶ AWS certification
      - ▶ AWS Cloud Practitioner
      - ▶ AWS Solutions Architect - Associate
      - ▶ AWS Solutions Architect - Professional
      - ▶ AWS SysOps Administrator
    - ▶ AWS Compute
    - ▶ AWS create IAM user
    - ▶ AWS Secrets Manager
    - ▶ AWS virtual private cloud (VPC)
    - ▶ Install the AWS cli tool
  - ▶ Azure
    - ▶ Azure certification
      - ▶ Azure Administrator Associate
      - ▶ Azure Fundamentals
      - ▶ Azure Solutions Architect Expert
    - ▶ Azure compute
      - Azure virtual machines
    - ▶ Azure Container apps
    - ▶ Azure Container instances
    - ▶ Azure Front Door
      - Azure Front Door best practices
    - ▶ Azure Functions
    - ▶ Azure Key Vault
    - ▶ Azure Kubernetes services (AKS)
      - AKS troubleshooting
    - ▶ Azure Management and Governance
    - ▶ Azure Monitor
      - ▶ Azure Application Insights
        
        Diagrams
        
        Resources
      - Readme
    - ▶ Azure SQL
      - Azure SQL Hyperscale
    - ▶ Azure Traffic Manager
    - ▶ Azure Virtual Network (VNET)
    - ▶ Azure VPN Gateway
      - Create an AWS to Azure site-to-site VPN
    - ▶ Bicep
    - Install the Azure cli tool
  - Cloud provider service equivalents
  - Create an AWS to Azure site-to-site VPN
  - ▶ Digital Ocean
    - ▶ Digital Ocean
  - ▶ Google Cloud Platform (GCP)
    - ▶ GCP Secret Manager
    - Install the GCP gcloud cli tool
  - ▶ Hetzner
  - ▶ OpenStack
    - ▶ OpenStack Neutron
  - Well-Architected Framework
- ▶ Infrastructure as Code (IaC)
  - ▶ Ansible
  - ▶ Kickstart
  - ▶ Terraform
- ▶ Observability
  - ▶ Elasticsearch
    - ▶ Index Lifecycle Management Ilm
      - Steady state
    - ▶ Install Elasticsearch
      - Install Elasticsearch in a container
      - Install Elasticsearch with RPM
  - ▶ Filebeat
  - ▶ Grafana
  - ▶ LGTM
  - ▶ Logstash
  - ▶ Loki
  - ▶ Mimir
  - ▶ Monit
  - ▶ Opensearch
  - ▶ Prometheus
  - ▶ Tempo
  - ▶ Vector
- ▶ CI CD
  - ▶ Jenkins
    - Install Jenkins
    - Securing Jenkins
  - Software Release Strategies
- ▶ Infrastructure
  - ▶ Cobbler
  - ▶ Domain Name System (DNS)
    - ▶ BIND
    - ▶ CoreDNS
    - ▶ DNS Explained
    - ▶ DNS Providers
      - ▶ Namcheap
        
        Create Namecheap DNS records
    - ▶ dnsmasq
    - ▶ DNSSEC
    - ▶ OctoDNS
    - ▶ PiHole
    - ▶ Systemd Resolved
    - ▶ Unbound
  - ▶ Kernel-based virtual machine (KVM)
  - ▶ Mail
- ▶ Site Reliability
- ▶ Berkeley Software Distribution (BSD)
- ▶ Containers
  - ▶ Docker
    - Docker logs
    - Docker run
- ▶ Content management systems (CMS)
- ▶ Databases
  - ▶ Relational Database Management System (RDBMS)
    - ▶ Galera
      - Create Galera cluster
    - ▶ MariaDB and MySQL
    - ▶ PostgreSQL
      - Postgresql HA Citus
- ▶ Desktop
  - ▶ Applications
    - ▶ Audacity
      - Create a ringtone
    - ▶ Bruno
      - Configure Bruno
      - Install Bruno
- ▶ DevOps
- ▶ Distributed Social Networking
  - ▶ AT protocol
  - ▶ Bluesky
  - ▶ Mastodon
    - Install Mastdon
  - ▶ Matrix
- ▶ Jellyfin
- ▶ Markdown
  - Markdown_formatting
- ▶ Message Queues
  - ▶ RabbitMQ
- ▶ Networking
  - ▶ CCNA exam
  - ▶ Network monitoring
    - Port mirroring
    - Tap devices
- ▶ Project management
  - ▶ OpenProject
    - Reset OpenProject admin password
- ▶ Quantum Computing
  - Basic Tenets of Quantum Computing
- ▶ Security
  - ▶ KeyCloak
    - Install Keycloak
    - Keycloak integration with Jenkins
  - ▶ Lets Encrypt
    - Create a Let's Encrypt wildcard certificate
  - ▶ Secret management
    - ▶ Infisical
    - ▶ Vault
- ▶ Software architecture
- ▶ Software development
- ▶ Technical writing
- ▶ Version control
- ▶ Web
  - ▶ Apache web server
  - ▶ HAproxy
  - ▶ Nginx
    - Nginx web server
  - ▶ Traefik
- ▶ Windows
  - ▶ Windows Desktop
    - Add App to Startup
  - ▶ Windows Server
- ▶ Blockchain
  - ▶ Cosmos
  - ▶ Ethereum
- ▶ Artifical Intelligence (AI)
  - GenAI's Environmental Impact
  - Running Generative AI Models Locally
Getting Started
▶ Resume
▶ Ecology
- ▶ Citizen Science
- ▶ Climate Change
- ▶ Danaus Plexipus
  - Reared count 2025
- ▶ Environmental Groups
- ▶ Indoor gardening
- ▶ Mushrooms
  - King Stropharia
  - Pioppino
- ▶ Native pollinator gardening
- ▶ Non Native Invasives
  - Common Buckthorn
- ▶ Reduce-reuse-recycle
- ▶ Turtles
▶ Food and drink
- Sardine cakes with white beans
▶ Misc
▶ Music

PostgreSQL¶

on this page