Sample Header Ad - 728x90

is it possible to run postgres with no WAL files being produced?

13 votes
2 answers
17328 views
I am looking at a way of running a 9.2 postgres database on redhat 6 without any WAL files being produced. We have a end of day batch process which generates a large number of WAL files (and has filled the disk a couple of times). We also take a pg_dump backup both before the start of the end of day process and also at the end. We are happy that should there be a problem during the batch process to restore the pre pg_dump backup. When i set the wal_level to minimal we are still getting a large number of WAL files due to the type of database updates which occur. So is it possible to have no WAL files as all (basically a wal_level=none)? thanks dave
Asked by davegreen100 (572 rep)
Jun 3, 2015, 12:38 PM
Last activity: Jun 24, 2024, 09:37 AM