BUG #1184: listeners not cleaned on crash - Mailing list pgsql-bugs

From PostgreSQL Bugs List
Subject BUG #1184: listeners not cleaned on crash
Date
Msg-id 20040627154050.A3C53CF4D10@www.postgresql.com
Whole thread Raw
Responses Re: BUG #1184: listeners not cleaned on crash
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1184
Logged by:          Radim Kolar

Email address:      hsn@netmag.cz

PostgreSQL version: 7.4

Operating system:   Freebsd 5.2.1

Description:        listeners not cleaned on crash

Details:

When postgres sql 7.4.1
 * crashes
 * shutdown immediate
 * kernel panics

After recovery, there are stalled entries in system catalogs which must
be removed by
delete from pg_catalog.pg_listener;

This is a very annoying bug if you are running slony1 replication system.

Radim Kolar

pgsql-bugs by date:

Previous
From: Michael Meskes
Date:
Subject: Re: ECPG doesn't return the correct length for an empty
Next
From: Joe Carlson
Date:
Subject: Re: BUG #1175: insert rule action with defaults