All Topics

Technology

Art

Migrating Specific Tables Between PostgreSQL Instances Using Logical Replication

ananthakumaran

7mo ago· 7 min readen

90/100

Golden Brown

Bagelometer↗

Crisp on the outside, thoughtful on the inside. A keeper.

Score90Typehow-toSentimentneutral

Summary

The article describes a technical process for moving specific tables between PostgreSQL database instances using native logical replication, as an alternative to Google's Database Migration Service which only supports full database migrations. The author explains why DMS wasn't suitable for their use case and details the step-by-step approach they implemented at work, including granting access to user accounts and other technical procedures involved in the replication process.

Key quotes

· 3 pulled

Unfortunately, that option was not available here, since DMS only allows the migration of an entire database, not specific tables within a database.

We chose the native logical replication option. It's a much more involved process compared to using DMS, but it provides greater flexibility and allows replication of specific tables only.

Grant access to user accounts

Snippet from the RSS feed

At work, we recently had to move a few tables from one PostgreSQL instance to another. In my previous post, I discussed how to use Google’s Database Migration Service (DMS) to migrate data from one instance to another. Unfortunately, that option was not a

You might also wanna read

PostgreSQL Transaction ID Wraparound Incident: A Production Database Outage Case Study

This article details a real-world PostgreSQL production incident caused by transaction ID wraparound, a critical database failure mode. The

sqlservercentral.com·1mo ago

Building a Custom PostgreSQL WAL Receiver: A Developer's Technical Journey

A developer shares their journey of deep technical exploration into PostgreSQL's WAL (Write-Ahead Log) system, starting from simple curiosit

medium.com·1mo ago

How to Modify FileZilla to Connect to Bambu 3D Printer's FTP Server

The article details a technical workaround for connecting FileZilla FTP client to a Bambu A1 Mini 3D printer. The author discovered that whi

lantian.pub·1mo ago

Guide to Running Google Gemma 4 AI Model Locally with LM Studio CLI on macOS

This article provides a technical guide on running Google's Gemma 4 26B parameter model locally using LM Studio's new headless CLI tools. It

ai.georgeliu.com·1mo ago

Technical Guide: Building a Blog with Elixir, Phoenix, and NimblePublisher

This article provides a technical guide on building a blog using Elixir and Phoenix framework, with NimblePublisher for generating blog post

jola.dev·2mo ago

Analyzing UDP Packets from Electrical Signals to Network Protocol Decoding

This technical article provides a hands-on guide to analyzing UDP packets starting from the physical layer using an oscilloscope and working

mattkeeter.com·2mo ago