Supersymmetry and Lorentzian holonomy in various dimensions