From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Gabriel E. Sánchez Martínez <gabrielesanchez@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: tables mysteriously truncated
Date: Wed, 13 Mar 2013 18:26:12 -0300
Message-ID: <20130313212612.GC3697@alvh.no-ip.org> (raw)
In-Reply-To: <5140C268.9080802@gmail.com>
References: <5140B917.5060405@gmail.com>
<CAF8jcqo+eqEuBrqp6=QhFrTDhg17He9hqiCMOhaMh9TfoYO5_w@mail.gmail.com>
<5140C268.9080802@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, gabrielesanchez@gmail.com
Subject: Re: tables mysteriously truncated
In-Reply-To: <20130313212612.GC3697@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox