#postgresql

Articles tagged with #postgresql

Zero‑Downtime PostgreSQL Migration Using Logical Replication
Migrating a production database is often a high-stakes operation. Traditional "dump and restore" methods require significant maintenance windows, leading to service downtime. To solve this, PostgreSQL offers Logical Replication, a native mechanism th...
Dec 17, 20254 min read67
Setting up PostgreSQL and configuring incoming connections
In this article, I'll give you a step-by-step guide on how to install the PostgreSQL database on Ubuntu 20.04. First of all, you'll need to update your sources using user@ubuntu:~$ sudo apt update Once that's done go ahead and use the apt package man...
Mar 6, 20224 min read209