Hey @alex I finally got Rebased + Soapbox installed on a DigitalOcean VPS with a DigitalOcean managed Postgres db.

Maybe I'll write a blog post later if I get time... some of these Pleroma db options were pretty difficult to track down between StackOverflow/git issues/forums.

There were some extra steps like:
• Manually create postgres and pleroma dbs at DigitalOcean
• Connect to the db remotely (I used TablePlus GUI) then execute the SQL in the config/setup_db.psql file on the managed db
• Download the ca cert from DigitalOcean managed db and transfer the file to /opt/pleroma/ca-certificate.crt
• Create a db pool at DigitalOcean with max 22 connections for the 1GB RAM db instance
• Modify config/prod.secret.exs and add the ssl, port, ssl_opts, pool_size, and queue_target options below:

config :pleroma, Pleroma.Repo,
adapter: Ecto.Adapters.Postgres,
username: "user",
password: "password",
database: "pleroma",
hostname: "my-unique-id.b.db.ondigitalocean.com",
port: 25060,
ssl: true,
ssl_opts: [verify: :verify_peer, cacertfile: '/opt/pleroma/ca-certificate.crt'],
pool_size: 10,
queue_target: 5000