I've had good luck with using just a small drop of super glue GEL. I put a drop or two in the hole and then push in the sight while trying to spin it in the glue for more bonding surface. I have only used this on periodic sights here and there never to reglue an entire set. Some other mechanics will chime in who have more experience than me.
Good Luck,
Gordon Graham
Las Vegas
PS
If you put excess glue of any kind it will squeeze out and create a mess.