Project title:
DevOps Engineer Needed: Self-Host Supabase on Ubuntu VPS
Posted by:
External project from PeoplePerHour
Started:
01-Nov-2025 12:30 GMT
Description:
Project Summary I’m looking for an experienced DevOps / Backend Engineer to set up and configure a self-hosted Supabase instance on my Ubuntu VPS. Docker is already installed, but it should be verified and properly configured. The goal is a secure, production-ready Supabase stack running locally (Postgres, Auth, REST, Realtime, Storage, Kong Gateway, and optional Studio), behind an HTTPS reverse proxy with automatic backups and full documentation. Scope of Work Docker & Environment Setup Verify existing Docker installation (version, permissions, network stability). Create dedicated Docker network (supabase_net). Prepare directory structure under /opt/supabase/. Supabase Stack Installation Deploy Supabase components using Docker Compose: Postgres GoTrue (Auth) PostgREST (REST API) Realtime Storage API Kong Gateway (Optional) Supabase Studio Configure .env and docker-compose.yml following best practices: No public database ports. All services communicate over internal Docker network. Security & Networking Set up Nginx reverse proxy for HTTPS with Let’s Encrypt certificates. Configure UFW firewall (only ports 22, 80, 443 open). Add security headers and enforce HTTPS redirects. Keep all credentials and secrets outside version control. Backups & Monitoring Implement automated daily PostgreSQL backups (with 30-day retention). Include a tested restore script. Add basic monitoring and health checks (Docker health, HTTP status). (Optional) S3-compatible offsite backup upload. Testing & Validation Verify user sign-up, login, and password reset via GoTrue (SMTP). Confirm REST endpoints respond via HTTPS. Validate Storage uploads/downloads. Test Realtime subscriptions. Run at least 3 negative RLS access tests. Documentation Provide a short runbook (README) including: Install, deploy, and rollback steps. Backup and restore instructions. Secrets handling. Service management commands. Include .env.example with comments. Deliverables Fully running self-hosted Supabase stack on Ubuntu VPS. docker-compose.yml, .env.example, and Nginx config files. Verified TLS certificate (Let’s Encrypt) and working HTTPS. Working Auth, REST, Storage, and Realtime endpoints. Automated daily database backup + successful restore test. Clean and concise documentation/runbook. Technical Environment Ubuntu 22.04 LTS Docker & Docker Compose v2 Nginx with Let’s Encrypt Domain & DNS already configured SSH access available Acceptance Criteria HTTPS active, A-grade SSL config, forced redirect HTTP→HTTPS PostgreSQL not publicly accessible Auth, REST, Storage, and Realtime endpoints all operational Backups run daily; restore script verified Logs rotate properly, disk usage monitored Only ports 22/80/443 open (UFW enabled) Documentation and .env.example delivered No hardcoded secrets in any file under version control Timeline & Deliverables Estimated workload: 1–2 working days setup, +1 day for testing and documentation. Deliverables pushed via Git repository and deployed on my VPS. Required Skills Docker & Docker Compose (production environments) Supabase or similar stacks (Postgres, GoTrue, Kong, Realtime) Linux server administration (Ubuntu) Nginx + Let’s Encrypt TLS setup Bash scripting (for backup/restore) PostgreSQL and basic SQL/RLS understanding Additional Notes Docker is already running but needs verification. Domain and DNS are fully configured. No Supabase cloud integration — this must be 100% self-hosted. Open to small improvements if you can make the setup more robust or secure.
Project ID:
3456238
Project category:
Project budget:
Project
Started
Source Quality BFGoodrich, Yokohama, Hankook and Other New Tyres
Category : Data Collection, Data Entry, Data Management, Inventory Management, Market Research, Product Research, Product Sourcing, Supplier Sourcing Budget : $10000 - $20000 USD
25-Feb-2026 23:03 GMT
Pizza Ordering Website Development
Category : CSS, Google Analytics, HTML, JavaScript, PHP, SEO, Web Development, Web Design, WordPress Budget : $250 - $750 USD
25-Feb-2026 23:02 GMT
Modern Detergent Label Design
Category : Adobe Illustrator, Photoshop, Graphic Design, Illustration, Label Design, Logo Design, Print Design Budget : $30 - $250 AUD
25-Feb-2026 23:00 GMT
Coastal Elevated Deck Design
Category : 3D Rendering, AutoCAD, Building Design, Structural Engineering Budget : $250 - $750 USD
25-Feb-2026 22:59 GMT
Shopify Product Research & AI Photography
Category : AI Content Creation, AI Development, AI Image Editing, AliExpress, Data Collection, Data Entry, Image Processing, Product Research, Product Sourcing, Web Search Budget : €30 - €250 EUR
25-Feb-2026 22:59 GMT
Handwritten Notes Transcription Needed
Category : Copy Typing, Data Entry, English Spelling, Google Docs, Microsoft Word, Transcription, Typing, Word Budget : $250 - $750 USD
25-Feb-2026 22:58 GMT
Xero Historical Data Entry
Category : Accounting, Bank Reconciliation, Bookkeeping, Data Management, Excel, Financial Analysis, Xero Budget : $8 - $15 AUD
25-Feb-2026 22:58 GMT
Online Will Creation Platform-Web base will writing software for Uk example freewills.co.uk
Category : API Development, Database Management, HTML, PHP, Software Architecture, Software Development, User Interface / IA, Web Application, Web Development, Web Design Budget : £250 - £750 GBP
25-Feb-2026 22:57 GMT
Corporate Business Flyer Design
Category : Adobe Illustrator, Adobe InDesign, Flyer Design, Graphic Design, Photoshop Budget : $30 - $250 USD
25-Feb-2026 22:56 GMT
Spatial.io Developer for Interactive Multi-Space Learning Environment
Category : 3D Animation, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, Game Design, Game Development, Gamification, Virtual Reality Budget : $250 - $750 USD
25-Feb-2026 22:55 GMT
AI-Based Mobile Skin Analysis App
Category : AI Development, AI Model Development, Android, Facial Recognition, IPhone, Machine Learning (ML), Matlab And Mathematica, Mobile App Development Budget : $15 - $25 USD
25-Feb-2026 22:54 GMT
Civil Engineer Needed – Gunnison, Colorado (Utility + Drainage Plan Revisions for Permit Resubmittal) -- 2
Category : AutoCAD, Building Architecture, Building Engineering, CAD / CAM, Civil Engineering, Construction Management, Environmental Engineering, Geotechnical Engineering, Project Management Budget : $1500 - $3000 USD
25-Feb-2026 22:52 GMT
Inspirational Fundraising Video
Category : Animation, Content Development, Creative Design, Crowdfunding, Fundraising, Video Editing, Video Production, Video Services Budget : $250 - $750 USD
25-Feb-2026 22:51 GMT
AWS DevOps Cost Optimization
Category : Audit, CI / CD, Data Processing, DevOps, Performance Tuning, Project Management, Technical Documentation, Terraform Budget : $25 - $50 USD
25-Feb-2026 22:51 GMT
Lighten Shadowed Portrait Faces
Category : Image Processing, Photo Editing, Photo Retouching, Photoshop Budget : $10 - $30 AUD
25-Feb-2026 22:50 GMT
Browse All Projects