I know WAL is new but how do you manage the WAL files. Do they need to get deleted everytime you back up the db? What is the best way to backup a Wharehouse? A transaction system? What do you do with the WAL files in each case? Is there an option to not use WAL logs? Currently I'm just using the pg_dumpall for lack of knowledge, but don't know what to do with the WAL files. Can anyone help with this?
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster