Self-Host
How to self-host PostgreSQL Database on Linux
Postgres is a performant SQL Database, and packs a ton of features. You can self-host Postgres on any linux machine including a Raspberry Pi. Read on to find out how.
Postgres
Database
Some commonly used Postgres commands
Taking selective backup in Postgres or inspecting which process is holding up transaction, you can get it all done pretty quickly. Here's how.
Database
Taking backup of Postgres Data using pg_dump
Taking periodic backup of data is considered a good practice for DBAs and in general for the entire product life cycle. For Postgres, taking backup could even be simple as a cakewalk