Re: [GENERAL] Postgresql logging questions

2012-01-30 Thread John R Pierce
On 01/30/12 12:14 PM, Heine Ferreira wrote: 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? yes, although it us

[GENERAL] Postgresql logging questions

2012-01-30 Thread Heine Ferreira
Hi 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.