Is pg_dump a backup tool? | Postgres.FM 124 | #PostgreSQL #Postgres podcast

preview_player
Показать описание
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Michael and Nikolay are joined by Gülçin Yıldırım Jelínek and Robert Haas to discuss both the technical question of whether or not pg_dump is a backup tool, as well as the tone and intent behind the statement "pg_dump is not a backup tool".

Here are some links to things they mentioned:

~~~

~~~

Postgres FM is produced by:

~~~

  1. PostgresTV 💙💛
Рекомендации по теме
Is pg_dump A 0:17:32

Is pg_dump A Backup Tool? | Scaling Postgres 331

Is pg_dump a 0:48:44

Is pg_dump a backup tool? | Postgres.FM 124 | #PostgreSQL #Postgres podcast

Webinar: Database Dumps 0:55:02

Webinar: Database Dumps and Backups

Backing up PostgreSQL 0:09:24

Backing up PostgreSQL users and groups (pg_dump and pg_dumpall)

PostgreSQL Logical Backup-Pg-dump| 0:09:10

PostgreSQL Logical Backup-Pg-dump| How to take backup using pg_dump

Backing Up a 0:06:36

Backing Up a Postgres Database with pg_dump and pg_restore

Use pg dump 0:07:35

Use pg dump to make a backup of your PostgreSQL database

How To Backup 0:11:52

How To Backup PostgreSQL Database With pg_dump And pg_dumpall From Server || Four Ways To Do Backup

Commodore 64 1541 0:37:39

Commodore 64 1541 Single Disk Backup Program Using One 1541 Disk Drive Copy Duplicate - Episode 2632

76- Daily backup 0:09:37

76- Daily backup schedule using pg_dumpall

PostgreSQL Backups: Essential 0:00:42

PostgreSQL Backups: Essential Guide to PG Dump Utility | Key Postgres Interview Question

PostgreSQL| Lec-20 | 0:05:33

PostgreSQL| Lec-20 | Backup & Restore | Part 4 : What is pg_dumpall

The Ultimate Neon 0:03:57

The Ultimate Neon Database Backup Script

PostgreSQL Backup and 0:43:05

PostgreSQL Backup and Recovery Methods

Different options to 0:08:42

Different options to backup postgresql cluster

PostgreSQL backup with 0:04:05

PostgreSQL backup with pg_dump

Think Your Postgres 0:42:45

Think Your Postgres Backups And Disaster Recovery Are Safe? Let's talk.

PostgreSQL| Lec-18 | 0:06:28

PostgreSQL| Lec-18 | Backup & Restore | Part 2 : What is pg dump utility.

Backup and Restore 0:09:11

Backup and Restore PostgreSQL Database: pg_dump and pg_restore Explained

PostgreSQL backup and 0:02:09

PostgreSQL backup and restore a database with pgAdmin 4

I Dropped My 0:55:42

I Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest - Charly Batista

How To Backup 0:02:42

How To Backup Database In PostgreSQL? - Next LVL Programming

PostgreSQL Database Backup 0:03:41

PostgreSQL Database Backup Automation

Part 21 - 0:24:36

Part 21 - PostgreSQL : What is a Pg_base backup.

Комментарии
Автор

Super content it's just like calling a tomoro a vegetable it hardly matters if it is a fruit or vegetable, it's the way we use it Peace 😂😂

yogeshdarne
Автор

This is important. But the bigger points are...
If you have not restored your backup. You don't have one.
If you have not validated your backup process, you're asking for trouble.

But 99% of the time, I need The Structure, The Code... And 90% of the data is not important to me.

That's a "dump" and not a "backup".

The final way I think about it is... Programmers use Dump Tools. And Operations Use Backup/Restore tools.

kirkwolak
Автор

48 minutes later and I still have no idea how I’m supposed to back up postgres.

GLuft
Автор

most useless topic I have listened on this channel, maybe the only one. but also it was fun

wexwexexort