Self-consistent equations for the two-dimensional non-neutral Coulomb gas and vortex fluctuations