1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 26-Feb-2026 04:56 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
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
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-2025 1001 Freelance Projects