Are physical backups sufficient in PostgreSQL? [closed]

Posted on

Question :

Should I make logical backupds too from time to time or are physical backups sufficient for recovery in case of emergency in PostgreSQL? What are the advantages of logical backups?

I have heard somewhere that physical backups are not reliable enough without logical ones. But do not know why.

Answer :

Physical backups can only be restored onto the same version of PostgreSQL running on the same OS and type of hardware. If you are running on obscure hardware or operating system, or ancient versions of PostgreSQL, this can be a problem. If you are not doing those things, it should not be a problem.

Leave a Reply

Your email address will not be published. Required fields are marked *