PostgreSQL 9.6, Disable archive log or minimal archive log size when do a pg_restore

0 votes

1 answer

282 views

                          I have a production DB PostgreSQL 9.6 that is on master/standby structure. Every at 1 AM I restore a few huge tables(from the other DB server) to the master node during restore till finished the archive log generated around 100GB. Is there any good way to minimize the archive_log from the pg_restore task?
                        

Asked by BongSey (119 rep)

Jan 7, 2020, 08:35 AM
Last activity: Jan 7, 2020, 09:01 AM

PostgreSQL 9.6, Disable archive log or minimal archive log size when do a pg_restore

Related Questions