On Thu, Oct 22, 2020 at 09:45:36AM +0200, W.P. wrote: > > There are many ways to do it. To be able to suggest proper solution we'd > > need to know: > > 1. what is the problem with pg_dump? > Time (I guess a bit, but copying files could be done using rsync, so much > faster). Is it *really* too slow for you? Please note that you can easily make it much faster by doing -Fd -j $( nproc ). > > 2. what is the exact problem you're solving (clearly it's not only > > "having backup", as this is done using pg_dump without any problem). > Maybe this is old way, but at some point of time I was doing Oracle 8 > backups just by copying files. > Also I guess, restore using copy files should be much faster than using psql > / pg_restore. You might want to read this: https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-LOWLEVEL-BASE-BACKUP Best regards, depesz
