PostgreSQL

Upgrading a PostgreSQL database server to a newer version is a common task for database administrators and developers. In this post, we will discuss how to upgrade a PostgreSQL database server running in a Docker container. On 1 January, I decided to upgrade the PostgreSQL used by my Mastodon instance. It was using PostgreSQL 12 and I think it could used the upgrade to PostgreSQL 15 for that “extra performance and features”....

I am currently having a side project that requiring JSON Blob feature on PostgreSQL 9.4. But Ubuntu 14.04 only delivering PostgreSQL 9.3 on their repositories. Now I’ll posting step by step how to install or upgrade if you already using PostgreSQL 9.3 on ubuntu 14.04 to PostgreSQL 9.4. ...

After setting up Manjaro on my new working laptop, I installed PostgreSQL 9.4. When I want to start the service by running sudo systemctl start postgresql, postgresql keep failing to start. ...