Postgresql logging questions

From: Heine Ferreira <heine(dot)ferreira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql logging questions
Date: 2012-01-30 20:14:08
Message-ID: CAMuqQjfO1D4hHXynNJ7H0yFQEKRX1J1R=8uBAXwyFNio2pujNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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.

Thanks

H.F.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-01-30 20:29:20 Re: Postgresql logging questions
Previous Message A.M. 2012-01-30 19:46:40 Re: restart server on Lion