"Christian DUPONT" <christian(dot)dupont(at)cegelec(dot)com> writes:
> I use slony 1 v 1.2.14.
> After an unexpected stop, several tables remained locked :
Is it possible that the locks are being held by a prepared transaction?
Next time it happens, look into the pg_prepared_xacts status view.
If it's not that, it seems like this must be a Slony issue, not a
problem with Postgres proper. You'll probably get better results
if you ask about it on the Slony mailing lists.
regards, tom lane