What are the best practices for deploying an application from a database to a virtual server?

Question

Software Deployment

Good afternoon! I have a full stack application running a database on my local machine (Next.js, Postgres/Prisma). It is necessary to deploy it to a remote server (the provider in my case is VScale / VDS), and, unfortunately, I have no one to ask now how to do it better.
What can I do: install Node.js, PostgresSQL on a remote server, point the repo from the github there and everything will work. We already have such experience.
What I would like to do:
1. Use Github actions for automatic deployment when deploying to the master (so far I have deployed only on Heroku)
2. Be able to backup the database, and, if necessary, transfer it to another server.

Tell me, how best to do it all (steps sequentially, or links where to read)? Where to begin? Do I need to use a docker container for the database? Will it all work fine on one server and is it normal practice to do this?

Answer 1

Backup and restore can be done using Postgres itself. Everything is simple there
. As far as I know, they try not to use docker for the database