I am still a big newbie as far as Postgresql is concerned. I got some questions about logging.
Most RDBMS's log all sql changes. When the server crashes or a power failure occurs and the server comes back up the rdbms rolls back to the nearest checkpoint and does a roll forward from the log.
Does Postgres also do this? If so is Postgres logging any beter than other databases? How good is Postgres at surviving power failures? This is of course assuming that you don't have a ups.