So you do some DBA work and one day realised that the worst has come true - the replication is just so broken you have to start all over. Usually there is always some kind of ground level when working with computers. If a program is badly broken try reinstalling it. If that does not work try reinstalling the OS maybe. If that does not work buy a new computer etc.

I had this situation on a system I am playing DBA on. Slony-I was badly broken so I had to restart from scratch. My ground zero was to drop the database and start over... But... what if you can't???

[postgres@A05L005 postgres]$ dropdb oasis
dropdb: database removal failed: ERROR: tuple already updated by self