GitHub Deployment to Ubuntu

Job ID: 39847024

Budget: ₹750 – ₹1,250 INR

I have a database-centric project sitting in a private GitHub repository that I want running on my own Ubuntu VPS. The core of the application works with PostgreSQL, so the job starts with securely pulling the repo, installing any language-specific dependencies, creating the required PostgreSQL role, database, and extensions, and wiring up the connection strings in my environment file.

The server already has MySQL installed; I don’t need you to reinstall it but I do want the configuration tightened—tweaking my.cnf, adjusting auth plugins if needed, and making sure the service plays nicely alongside PostgreSQL without port conflicts or unnecessary resource use.

What I will consider a complete hand-off:
• Repository cloned to /var/www/<project> (or another agreed-on path) with correct permissions
• Systemd or an equivalent service file enabling the app to start automatically on reboot
• PostgreSQL database created, migrations (if any) run, and connection confirmed via the app’s health endpoint
• MySQL configuration updated as discussed and the service restarted cleanly
• A short README listing every command you executed so I can reproduce this on a staging box later

If you are comfortable with Ubuntu 22.04, PostgreSQL 15+, and general Linux service hardening, I’d like to get this done within the next day or two. Let me know your approach and any clarifying questions.
Related categories: Linux Database Administration VPS PostgreSQL Ubuntu Git