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
Last activity: Jun 24, 2024, 09:37 AM