On Tue, 14 May 2019, Adrian Klaver wrote:
Or just fetch them from the table data you have saved in the dump file.
Adrian, This did save a lot of time! Thanks for the pointer.
And I think I'll set up a cron job to do a database dump each day with the date appended to the file name in the bash shell script.
Yeah, that will save a lot of heartburn:)
Done. Cron will run the shell script at 02:15 each day. This will do until I build, install, and configure pgBackRest (which consumes less disk space than do the daily pg_dumpall files. Best regards, Rich
