Andrew Mercer

▶ Docs
- Getting Started
- ▶ Linux
  - ▶ Linux core subsystem
    - ▶ Bash and built-ins
      - Bash one-liners
    - ▶ coreutils
    - ▶ Systemd
      - systemd: A Comprehensive Overview
    - ▶ util-linux
      - ▶ Ionice
        
        Readme
      - ▶ logger
      - ▶ 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
    - Debian/Ubuntu
    - Delv
    - Dig
    - Dog
    - Iptables
    - Ipvs
    - Linux router
    - Network Namespaces
    - Nping
    - Ping
    - Tcpdump
    - Wireshark
  - ▶ Linux performance & monitoring
  - ▶ Linux tools
- ▶ 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
  - 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
  - A History of Modern Centralized Logging: Linux, BSD & Microsoft
  - ▶ Elasticsearch
  - ▶ Filebeat
  - ▶ Grafana
  - ▶ LGTM
  - ▶ Logstash
    - Logstash reference guide
    - Logstash — Architecture, Troubleshooting & Testing
  - ▶ Loki
  - ▶ Mimir
  - ▶ Monit
  - ▶ Opensearch
  - ▶ Prometheus
  - ▶ Tempo
  - ▶ Vector
- ▶ CI CD
- ▶ Infrastructure
  - ▶ Cobbler
  - ▶ Domain Name System (DNS)
    - ▶ BIND
    - ▶ CoreDNS
    - ▶ DNS Explained
    - ▶ DNS Providers
      - ▶ Namcheap
        
        Create Namecheap DNS records
    - ▶ dnsmasq
    - ▶ DNSSEC
    - ▶ OctoDNS
    - ▶ PiHole
    - ▶ Systemd Resolved
    - ▶ Unbound
  - ▶ Foreman
  - ▶ Katello
  - ▶ Kernel-based virtual machine (KVM)
  - ▶ Mail
  - ▶ OpenSSH
- ▶ Site Reliability
- ▶ Berkeley Software Distribution (BSD)
- ▶ Containers
  - ▶ Argocd
    - ArgoCD and Flux: How They Intersect and Complement Each Other
    - ArgoCD: A Comprehensive Guide
  - ▶ Docker
    - Docker logs
    - Docker run
  - ▶ Fluxcd
    - Flux (Flux CD / GitOps Toolkit): A Comprehensive Guide
  - ▶ Kubernetes
    - ▶ kubectl
      - kubectl debug
    - ▶ vCluster
  - ▶ Kubernetes the hard way
- ▶ Content management systems (CMS)
- ▶ Data formats
- ▶ Databases
  - ▶ Relational Database Management System (RDBMS)
    - ▶ Galera
      - Create Galera cluster
    - ▶ MariaDB and MySQL
    - ▶ PostgreSQL
      - Postgresql HA Citus
      - Reset PostgreSQL user password
- ▶ Desktop
  - ▶ Applications
    - ▶ Audacity
      - Create a ringtone
    - ▶ Bruno
      - Configure Bruno
      - Install Bruno
- ▶ DevOps
- ▶ Distributed Social Networking
  - ▶ AT protocol
  - ▶ Bluesky
  - ▶ Mastodon
    - Install Mastdon
  - ▶ Matrix
- ▶ Jellyfin
- ▶ Message queues
  - Message Queues Guide
- ▶ Message Queues
  - ▶ RabbitMQ
- ▶ Networking
  - ▶ CCNA exam
  - DNS encryption TAP audit
  - ▶ Network monitoring
    - Port mirroring
    - Tap devices
- ▶ Project management
  - ▶ OpenProject
    - OpenProject — Homelab Deployment
    - Reset OpenProject admin password
- ▶ Quantum Computing
  - Basic Tenets of Quantum Computing
- ▶ Security
- ▶ Software architecture
- ▶ Software development
- ▶ Technical writing
- ▶ Version control
- ▶ VoIP
  - ▶ Asterisk
  - ▶ FreePBX
    - FreePBX Setup & Troubleshooting Guide
  - Hosted PBX
  - The Open-Source VoIP / PBX Ecosystem in 2026: A Review
  - ▶ Trixbox
- ▶ Web
  - ▶ Apache web server
  - ▶ HAproxy
  - ▶ Nginx
    - Nginx web server
  - ▶ Traefik
- ▶ Windows
  - ▶ Windows Desktop
    - Add App to Startup
  - ▶ Windows Server
- ▶ Blockchain
  - ▶ Bitcoin
  - ▶ Cosmos
  - ▶ Ethereum
- ▶ Artifical Intelligence (AI)
  - ▶ Large language models (LLM)
  - Running Generative AI Models Locally
▶ Resume
▶ Ecology
- ▶ Citizen Science
- ▶ Climate Change
- ▶ Danaus Plexipus
  - Reared count 2025
- Ecology Foundations & Environmental Stewardship
- ▶ Environmental Groups
- Environmentalism
- ▶ Indoor gardening
- ▶ Mushrooms
  - King Stropharia
  - Pioppino
- ▶ Native pollinator gardening
- ▶ Non Native Invasives
  - Common Buckthorn
- ▶ Reduce-reuse-recycle
- The Complete Guide to Tree Management
- ▶ Turtles
▶ Food and drink
- ▶ Cast iron
- ▶ Recipes
▶ Misc
- ▶ Artificial Intelligence (AI)
  - GenAI's Environmental Impact
- ▶ Homemade stuff
  - Homemade glasses cleaner
- ▶ Kintsugi
▶ Music
▶ Outdoors
- ▶ Camping
  - ▶ Backcountry camping

on this page

PostgreSQL¶

in this section

* postgresql ha citus

* reset postgresql user password