Resolving the Galactic ridge X-ray background