Dan Gorman <dgorman@xxxxxxx> writes: > This snapshot is done at the LUN (filer) level, postgres is un-aware > we're creating a backup, so I'm not sure how pg_start_backup() plays > into this ... That method works too, as long as you snapshot both the data files and WAL files --- when you start PG from the backup, it will think it crashed and recover by replaying WAL. So, assuming that the snapshot technology really works, it should be exactly as reliable as crash recovery is. If you saw a problem I'd be inclined to question whether there is some upstream component (OS or disk controller) that's reordering writes. regards, tom lane
