But do you have statements which causes Exclusive Locks? Ignoring them in OLTP won't make your life any easier.(Keeping avoiding to get into 'recovery conflict' as your sole goal) If you decide to run pg_dump from master, it would block such statements which have Exclusive locking. This would cause delays, deadlocks, livelocks etc and it might take a while for your before you can figure out what is going on.I would say try to find out who is and why is someone creating Exclusive locks.
Yeah! The pg_dump was already running on the master... it's been running for months.. I just wanted to change now to use the slave, but it seems I can't right?
Exclusive locking - I probably have statements that causes this. Is there any way I could "track" them?
