Supersymmetry in Lorentzian Curved Spaces and Holography