Like it says at the bottom of every 5-6 emails :
subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
OR
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
It's quite simple really.