In the talk you stated that pg_dump is not a backup, but never explained why. The first paragraph of the man page for pg_dump says, "pg_dump is a utility for backing up a PostgreSQL database," which seems to disagree with you. ???
Thanks for your comment. pg_dump can only produce logical backups that are useless for things such as point-in-time-recovery. Moreover, it doesn't have automation, monitoring or alerting so you have to provide all those yourself. The documentation has been there since before other PostgreSQL backup tools existed, and is accurate insofar as that pg_dump *can* be used as a backup tool, but I would not consider it a good solution for your only backup method.
![Don't make these mistakes with #PostgreSQL! [Don't Do This @ #FOSDEM 2023]](http://i.ytimg.com/vi/vxuPW4Ottrk/mqdefault.jpg)
![Don't make these mistakes with #PostgreSQL! [Don't Do This @ #FOSDEM 2023]](/img/tr.png)
![PostgreSQL Data Recovery with NO BACKUP! (True Story) [SCaLE 21x]](http://i.ytimg.com/vi/mdjf9KtW92M/mqdefault.jpg)
![Slow things down to make them go faster? [#FOSDEM 2022] #PostgreSQL](http://i.ytimg.com/vi/YvUTsl0isyc/mqdefault.jpg)
Fantastic Your content
In the talk you stated that pg_dump is not a backup, but never explained why. The first paragraph of the man page for pg_dump says, "pg_dump is a utility for backing up a PostgreSQL database," which seems to disagree with you. ???
Thanks for your comment. pg_dump can only produce logical backups that are useless for things such as point-in-time-recovery. Moreover, it doesn't have automation, monitoring or alerting so you have to provide all those yourself. The documentation has been there since before other PostgreSQL backup tools existed, and is accurate insofar as that pg_dump *can* be used as a backup tool, but I would not consider it a good solution for your only backup method.