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

Install PostgreSQL 10 on on new VPS #simpleanalytics

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…

update deployment to use DigitalOcean Postgres #monita

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

deploy postgres to kubernetes #monita

#redacted Docker Compose all nice and running. Django + Redis + Postgres (pgAdmin+pghero) + Celery (Beat + Flower). For Frontend have Vite+React in a solid starting position.

Swapped Postgres docker image to Postgis to enable Directus map features #ziarnisty

Work on postgres starter #shipnix

prepare new Postgres database #spectate