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
Ghostwrite & Book Manuscript Editing and proofreading Category: Biography Writing, Book Writing, Content Writing, Copy Editing, Creative Writing, Editing, Fiction, Ghostwriting, Non Fiction Writing, Proofreading Budget: $30 - $250 USD	01 Nov 2025 23:04 GMT
Remote B2B Phone Sales Assistant Category: CRM, Customer Service, Customer Support, Lead Generation, Leads, Sales, Sales Management, Telemarketing Budget: $250 - $750 USD	01 Nov 2025 23:04 GMT
BPO Recruiter Needed Category: BPO, Customer Service, Employee Engagement, HR Sales, Human Resources, Interviewing, LinkedIn Recruiting, Recruitment, Sourcing, Talent Acquisition Budget: $30 - $250 USD	01 Nov 2025 23:04 GMT
Research Article Text Mining for Meta-Analysis Category: Data Entry, Data Extraction, Data Mining, Data Processing, Data Visualization, Excel, NLP, Python, Statistical Analysis, Statistical Modeling Budget: $30 - $250 USD	01 Nov 2025 23:04 GMT
React Native Virtual Goods App Category: Android, Backend Development, Figma, Inventory Management, JavaScript, Mobile App Development, PhoneGap, React Native Budget: €2 - €6 EUR	01 Nov 2025 23:03 GMT
Sustainable Strategy Development for Manufacturing - 01/11/2025 18:33 EDT Category: Business Analysis, Business Plans, Business Writing, Environmental Consulting, Manufacturing Strategy, Research Writing, Supply Chain, Sustainability Budget: £250 - £750 GBP	01 Nov 2025 23:00 GMT
Comprehensive Content Marketing Strategy Category: Article Writing, B2B Marketing, Content Creation, Content Management System (CMS), Content Marketing, Content Writing, Digital Marketing, Internet Marketing, Marketing, Marketing Strategy Budget: $30 - $250 USD	01 Nov 2025 22:59 GMT
Customer & Logistics Support Category: Audio Services, Customer Service, Customer Support, Data Entry, English (UK) Translator, English (US) Translator, Logistics, Operations Management, Time Management, Voice Talent Budget: $30 - $250 USD	01 Nov 2025 22:56 GMT
Jamaican Cookbook with Photos Category: Adobe Illustrator, Adobe InDesign, Content Creation, Graphic Design, Illustration, Photography, Photoshop, Print Design Budget: $250 - $750 USD	01 Nov 2025 22:55 GMT
Experto SEO Gemini y ChatGPT Category: ChatGPT Search Optimization, Link Building, Search Engine Marketing (SEM), SEO, SEO Auditing, White Hat SEO Budget: €30 - €250 EUR	01 Nov 2025 22:46 GMT
Criar um logotipo Category: Graphic Design, Illustration, Logo Design, Photoshop Budget: $30 - $250 USD	01 Nov 2025 22:41 GMT
Course Booking Website Development Category: Graphic Design, HTML, Payment Gateway Integration, PHP, Web Design, Web Development Budget: £20 - £250 GBP	01 Nov 2025 22:40 GMT
Ontario House Blueprint Modification Category: AutoCAD, Building Architecture, Building Design, Building Regulations, CAD / CAM, Construction Engineering, Construction Management, Interior Design Budget: $250 - $750 CAD	01 Nov 2025 22:40 GMT
Metafox Cloudflare Fix & Optimization Category: AJAX, Apache, Cloudflare, Google PageSpeed Insights, Laravel, MySQL, PHP, React Native, React.js, Troubleshooting Budget: $25 - $50 USD	01 Nov 2025 22:39 GMT
Realistic Birthday Card Art Category: 2D Drawing, Art Consulting, Character Illustration, Color Grading, Creative Design, Drawing Artist, Graphic Design, Illustration, Sketching, Watercolor Painting Budget: $30 - $250 AUD	01 Nov 2025 22:38 GMT

Browse All Projects

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