This article states that PAllen's intuition, that additional constraints are needed for the curvature to be integrated to a metric, is correct.
Hernando Quevedo
Determination of the metric from the curvature
General Relativity and Gravitation, Volume 24, Number 8, 799-819, DOI: 10.1007/BF00759087
Let Tabcd be the components of a tensor defined on a coordinate domain of M. ... It is easy to see that this tensor possesses the same symmetry properties as those of the curvature tensor. ... find a metric tensor gij (or equivalently a tetrad vga) in terms of a and b such that its curvature tensor Rabca coincides with the tensor Tabca. Note that the manifold M does not carry any connection; it is, therefore, not possible to say whether or not Tabcd is a curvature tensor. This is true only if Tabcd satisfies the Bianchi identities which involve its covariant derivatives. Indeed, the Bianchi identities can be interpreted as the integrability condition of the differential equations relating the components of a curvature tensor with the metric components (see, for instance, Ref. 25).
Quevedo's Reference 25 is Stephani's
http://books.google.com/books?id=WAW-4nd-OeIC&source=gbs_navlinks_s". On p143 Stephani writes "The determination of the metric from a specified curvature tensor amounts ... to the solution of a system of twenty second-order differential equations for the ten metric compoenents ... In general such a system will posess no solutions ..." He then lists explicitly the additional differential constraints needed.
PAllen, much thanks for bringing this up! I had asked myself this question before, and resolved it wrongly based on my reading of Berger (who says nothing wrong, I just over-interpreted him). Unfortunately, all this now irrelevant, since Lorentzian spacemites don't exist, right?
