Re: Notify system doesn't recover from "No space" error

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Christoph Berg <christoph.berg@credativ.de>

Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-hackers@postgresql.org, Joachim Wieland <joe@mcknight.de>

Date: 2012-07-02T16:03:55Z

Lists: pgsql-hackers

Christoph Berg <christoph.berg@credativ.de> writes:
> What is still puzzling me is that the customer is repeatedly reporting
> these issues, even after rebooting the system.

Hm.  A server restart really ought to clear any problem in this area,
since pg_notify gets reset to starting conditions.  Please check into
that more closely.  (It might be worth looking at $PGDATA/pg_notify/
after a restart just to verify there are no files there except 0000.)

			regards, tom lane