Pseudo-Riemannian Metric on Manifold
Solution 1:
A necessary and sufficient condition for a smooth $n$-manifold $X$ to admit a metric of signature $(r, s)$ is that the tangent bundle admits a direct sum decomposition into a bundle of rank $r$ and a bundle of rank $s$, or equivalently that the tangent bundle admits a reduction of the structure group to $GL_r \times GL_s$.
When either $r$ or $s$ is equal to $1$ this is equivalent to the existence of a nonvanishing vector field, which is automatic when $X$ is noncompact and governed by whether $\chi(X) = 0$ otherwise, by the Poincaré–Hopf theorem.
In general I think it's a difficult question to determine when this reduction is possible. There are necessary conditions coming from characteristic classes which show that, for example, an even-dimensional sphere $S^{2n}$ does not admit a metric of any indefinite signature. A sufficient condition is that the manifold smoothly fibers over an $r$-manifold (or an $s$-manifold).
Solution 2:
This doesn't answer the general question, but Proposition 5.37 from O'Neill's Semi-Riemannian Geometry might be of interest:
Proposition. For a smooth manifold $M$ the following are equivalent:
(1) There exists a Lorentz metric on $M$.
(2) There exists a time-orientable Lorentz metric on $M$.
(3) There is a nonvanishing vector field on $M$.
(4) Either $M$ is noncompact, or $M$ is compact and Euler number $\chi(M)=0$.