1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 01-Nov-2025 22:21 GMT
View Project
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)
Last Projects / Browse Projects
  Project Started
MYHCA - Make Your Hands Clean Again .... a bit of fun! 01-Nov-2025
14:51 GMT
Tech pack. 01-Nov-2025
14:49 GMT
Pine script for TradingView 01-Nov-2025
13:24 GMT
I want a poster created 01-Nov-2025
12:46 GMT
Responsive HTML Email Developer for Gmail & Outlook 01-Nov-2025
12:46 GMT
Increase TikTok Following 01-Nov-2025
12:34 GMT
DevOps Engineer Needed: Self-Host Supabase on Ubuntu VPS 01-Nov-2025
12:30 GMT
Technical User Manual Creation 01-Nov-2025
11:10 GMT
Bilingual Tech CV Revamp
Category: Artificial Intelligence, Editing, Graphic Design, Language Tutoring, Proofreading, Technical Writing, Web Development, Word Processing
Budget: $10 - $30 USD
01-Nov-2025
11:04 GMT
Telugu Tech Tutor Needed
Category: Artificial Intelligence, Blockchain, Data Science, Generative AI, Internet Of Things (IoT), Machine Learning (ML), Natural Language Processing, Quantum Computing
Budget: ₹600 - ₹1500 INR
01-Nov-2025
11:04 GMT
Premium Photo Retouching Needed
Category: Adobe Lightroom, Photoshop, Background Removal, Image Processing, Photo Retouching, Photoshop Design
Budget: $250 - $750 USD
01-Nov-2025
11:04 GMT
Estudio acústico simplificado para generador electrógeno según normativa específica
Category: Cartography & Maps, Sound Engineering
Budget: €40 - €80 EUR
01-Nov-2025
11:04 GMT
Odoo Module Tweaks & Fixes
Category: ERP, Git, Odoo, PHP, Python, Software Architecture, Software Development, XML
Budget: ₹400 - ₹750 INR
01-Nov-2025
11:04 GMT
Wardrobe Essentials Style Advisor
Category: Fashion Consulting, Fashion Design, Fashion Modeling, Fashion Writing, Textile Design
Budget: $2 - $8 USD
01-Nov-2025
11:02 GMT
Business Partner / Investment Opportunity in Distribution Business - 01/11/2025 06:46 EDT
Category: Business Analysis, Business Development, Business Management, Business Strategy, Project Management
Budget: $10 - $30 USD
01-Nov-2025
11:02 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2024 1001 Freelance Projects