Backup with pg_dump and Restore One Database
Dump one PostgreSQL database in custom format, store it off the data disk, and restore it with pg_restore into a clean target cluster safely.
Databases8 min read
NetBay journal
Guides for operators
Practical guides for Linux, containers, CI/CD, self-hosting, and running VPS infrastructure from Netbay Engineering.
599 articles · 24 topics
AllLinuxLinux AdministrationWindowsLinux SecurityLinux NetworkingContainersContainers & OrchestrationKubernetesCI/CDGitHubSelf-HostingBackups & DataDatabasesApp DeploymentDNS & TLSObservabilityEmailAI AgentsAI InfrastructureAPI & AutomationProxiesCloud ArchitectureHardware & PerformanceDevOps Practices
PHP Permissions: www-data, Deploys, Writable Dirs
Set PHP file ownership so a deploy user ships code, www-data can read it, and only storage, cache, and upload directories stay group-writable on the VPS.
App Deployment8 min read
EPEL Repository: What It Adds and How to Enable It Safely
EPEL adds thousands of community packages to RHEL-family servers. Enable it right: base-repo priorities and package exclusions keep the layering deterministic.
Linux6 min read
GitHub Pages Deploys from Actions: Static Sites
Automate static site builds and GitHub Pages deploys with configure-pages, upload-pages-artifact and deploy-pages actions in a single workflow.
GitHub7 min read
Proxy Caching: Serve Safe Stale Assets and Pages
Cache static assets and API answers at the proxy with stale-while-revalidate so a slow or broken upstream never becomes a slow user experience.
Proxies8 min read
Postfix as a Smarthost Relay to a Real ESP
Keep local sendmail and cron working, but hand the public hop to SES, Mailgun, or Postmark. Postfix sasl_passwd and smtp_tls are the whole design.
Email8 min read
SSH Reverse Tunnels to Expose a Local Service
Publish a laptop or lab port through a Lucknow VPS with ssh -R, bind it on localhost, and keep the tunnel alive without opening the lab to the internet.
Linux Administration8 min read
Host Private LLM Inference on a Single VPS
Bind a local 7B to loopback, cap RAM and threads with systemd, and let only your app call it so private prompts never leave a Lucknow VPS host.
AI Infrastructure8 min read
SQLite Indexes and Why LIKE %x Will Not Use Them
SQLite B-tree indexes match left-most prefixes, so LIKE with a leading percent cannot seek; use suffix indexes, FTS, or a stored reverse column.
Databases8 min read
HTTP-01 vs DNS-01: Choosing an ACME Challenge
Compare HTTP-01 and DNS-01 ACME challenges, pick the one that fits nginx on a VPS versus wildcards, and avoid the common failure modes of each.
DNS & TLS8 min read
RAG Ingest Pipeline: Git Pull, Embed, Upsert
Pull a docs repo, chunk the diff, embed new blobs, and upsert by path so your local VPS RAG index tracks git instead of a full nightly rebuild.
AI Infrastructure9 min read
cron vs systemd Timers: Scheduling Jobs on Modern Linux
Compare classic cron with systemd timers for scheduling recurring jobs, and learn when each fits better.
Linux6 min read