Moduli stabilization and the holographic RG for AdS and dS