1001 Freelance Projects -- DevOps Engineer Needed: Self-Host Supabase on Ubuntu VPS

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
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:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
4D Kids Cartoon Animator Category: 2D Animation, 3D Animation, 3D Design, 3D Graphic Design, 3D Rendering, After Effects, Animation, Maya Budget: $750 - $1500 USD	19 Jan 2026 23:04 GMT
Dynamic Excel Recipe Costing Workbook Category: Data Entry, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Financial Modeling, Visual Basic Budget: $250 - $500 AUD	19 Jan 2026 23:03 GMT
Multifaceted Virtual Assistant needed Category: Admin Support, Data Entry, Email Handling, Virtual Assistant, Web Search Budget: $2 - $8 USD	19 Jan 2026 23:00 GMT
iOS App Developer (SwiftUI) — Local-Only App, No Backend Category: Agile Development, App Development, IOS Development, IPhone, Mobile App Development, Mobile App Testing, Objective C, Swift Budget: $750 - $1500 NZD	19 Jan 2026 23:00 GMT
Non-IT Sourcer Specialist Needed (Recruiter) Category: Accounting, Admin Support, Construction Management, CRM, Finance, Google Docs, Human Resources, Marketing, Sales, Sourcing Budget: $2 - $8 USD	19 Jan 2026 23:00 GMT
Canva whizz needed Category: Canva, Graphic Design, Illustration, Instagram Marketing, Photoshop, Photoshop Design, Social Media Marketing, Visual Design Budget: $30 - $250 AUD	19 Jan 2026 22:59 GMT
Dark Luxury Pricing Page Design & Integration (Premium Adult Website) -- 2 Category: Figma, Graphic Design, HTML, Logo Design, MongoDB, Node.js, UI / User Interface, User Interface / IA, UX / User Experience, Web Design Budget: €750 - €1500 EUR	19 Jan 2026 22:57 GMT
Luxury Perfume Collection Creative Design Lead Category: 3D Rendering, Branding, Corporate Identity, Creative Design, Design Thinking, Graphic Design, Logo Design, Packaging Design, Product Design, Visual Design Budget: $10 - $30 USD	19 Jan 2026 22:54 GMT
Simple Single-Layer PCB Design Category: Circuit Design, Embedded Systems, Microcontroller, PCB Design And Layout, PCB Layout, Prototyping Budget: $30 - $250 CAD	19 Jan 2026 22:54 GMT
Lead Generation (B2B) / Appointment Setter / Cold Calling Specialist - Construction Focus Category: Appointment Setting, B2B Marketing, Business Development, CRM, Customer Service, Data Entry, Lead Generation, Leads, Sales, Telemarketing Budget: $2 - $8 USD	19 Jan 2026 22:54 GMT
Need a YouTube video Editor Category: After Effects, Animation, Cartography & Maps, Geographical Information System (GIS), Motion Graphics, Video Ads, Video Editing, Video Production, Video Services, YouTube Budget: $30 - $250 USD	19 Jan 2026 22:52 GMT
Animation Voiceover Narration (Updated requirements) Category: Audio Editing, Audio Engineering, Audio Production, Voice Acting, Voice Over, Voice Talent Budget: $30 - $250 USD	19 Jan 2026 22:52 GMT
Technical Report on Crop Management and Irrigation Category: Agronomy, Data Analysis, Data Visualization, Report Writing, Research Writing, Statistical Analysis, Technical Writing Budget: $25 - $50 USD	19 Jan 2026 22:50 GMT
Bank Reconciliation Specialist Needed Category: Account Management, Account Payables Management, Accounting, Accounting Tutoring, Bank Reconciliation, Finance, Intuit QuickBooks, Payroll Budget: $250 - $750 CAD	19 Jan 2026 22:49 GMT
Move-Out Entire House Cleaning Category: Domestic Cleaning, House Cleaning Budget: $250 - $750 AUD	19 Jan 2026 22:48 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)