Craig Kerstiens • 9/3/2017

Postgres backups: Logical vs. Physical an overview

Read Original

This technical article provides an overview of the two primary backup methods in PostgreSQL: logical backups (using pg_dump) and physical backups (using WAL and base copies). It details how each works, their pros and cons, including performance impact, portability, and recovery processes, to help database administrators choose the right strategy.

0 comments
#postgresql #Database Backup #Pg_dump
Postgres backups: Logical vs. Physical an overview

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert • 2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes
4
Wagon’s algorithm in Python
John D. Cook • 1 votes
5
An example conversation with Claude Code
Dumm Zeuch • 1 votes