The Poisson equation on Riemannian manifolds with weighted Poincaré inequality at infinity