Back
Similar todos
Setup production Postgres at Digital Ocean 
#clanlatamdb
- upgrade postgres to v14 in production-external see learning in [[how to upgrade major versions of postgres in docker for production|postgres.levelup#how-to-upgrade-major-versions-of-postgres-in-docker-for-production]] #enpvqp
published postgres with self-signed ssl docker image
switched my default Docker Compose Postgres image to use image: "pgautoupgrade/pgautoupgrade:latest" instead to avoid having to think about doing database upgrades in my projects.
Decide to self-host postgres database with automated daily backups for now. Managed database on DigitalOcean just added complications instead of eliminating #shipnix
Connect a free postgresdb so I can put it on Vercel instead of locally with Sqlite 
#buildstreak
Make postgresql available outside my VPS 
#simpleanalytics
Moved my database over from neon.tech to the VPS. No use paying $20 a month for a postgres database. 
#aichatemail
manage to setup postgresql DB locally #codercestcool
My next goal is to get postgres working locally instead of sqlite b/c apparently it's easier to use postgres on dokku(?). Installed postgres on my macbook using postgresapp.com, it was so easy 😭 Connected GoLand to a new postgres db for my backend; got my backend code working with the postgres db; committed and pushed my code. Next step is to continue with this guide: shellbear.me/blog/go-dokku-de…
upgraded the production postgresDB
move postgres 
#downpayment
- upgraded to postgres 14 on local dev for greendeploy #greendeploy
Tried to upgrade the fly.io Postgres machine memory, and it simple failed to start afterwards. Quickly migrated prod db to self-hosted Postgres on Hetzner. Hate these infrastructure wrappers you don't have any control. 
#2markdown
Work on postgres starter #shipnix
prepare new Postgres database 
#spectate
Check healthy Docker instance + Postgres instance for Umami, holding up good for normal production traffic 
#prompthero
Add Postgres 17 support to 
#indiepg