On Thu, Aug 22, 2024 at 10:22 AM Greg Sabino Mullane <htamf...@gmail.com> wrote:
> On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor <o1bigte...@gmail.com> wrote: > >> >> >> On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson <ronljohnso...@gmail.com> >> 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!
