When re-taking psych, you should take it at your 4 year college.
Rightly or wrongly, CC classes have a reputation of being less rigorous than coursework offered by 4 year colleges and universities.
You need to show that you can compete on the (presumed) more rigorous level of a 4 year college after failing a CC class.