DB9 is not ideal but would work. You can get them with IDC connections so you don't have to solder 9 wires.
They are a pain to make the hole though.
What about DIN connectors, they come in many pin numbers, lock in, and don't have a weird shape so holes are easy.
Rob