"Gabriel E. Sánchez Martínez" escribió: > I will try to make these tables logged and see if they withstand the > test of time. Are crashes and unclean shutdowns logged anywhere? I > would like to see why I might be getting them. I have not had to > manually restart the database, if that were an indication of a > crash.
Yes, crashes are logged in the server log. There's support for automatic recovery and restart after a crash, so it's quite plausible that you're not seeing anything if you're not paying attention. Sessions that were running prior to the crash are terminated, though, so if you keep connections open, you'd notice because they would no longer work. Crashes should certainly not happen routinely. If they are, you have a problem that's worth investigating. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
