Honestly, I doubt Obama was ever really against gay marriage, he's just a politician who panders to whatever position he thought would get him the most votes.

In 2008, the "moderate" position was to support civil unions, while opposing full equality. So that's what Obama did. Now, in 2014, the needle has shifted. Gay marriage has become increasingly mainstream.