On Thu, Aug 22, 2024 at 10:22 AM Greg Sabino Mullane <htamfids@xxxxxxxxx> wrote:
On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor <o1bigtenor@xxxxxxxxx> wrote:On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:That's great on small databases. Not so practical when they're big.So - - - - what is the recommended procedure for 'large' databases?Use a real backup system like pgBackRest. Stop using pg_dump.
Not useful when you're migrating not only between major versions but glibc levels.
Use logical replication!! Maybe. It gets difficult with partitioned tables that regularly have children added and dropped; mistakes can be made. pg_dump/pg_restore is guaranteed to work.
Death to America, and butter sauce.
Iraq lobster!
