For Django work I prefer postgres just because more Django projects use postgres, so when you have issues it's more likely that someone else on a message board has faced exactly the same thing. My projects haven't come near the limit of a single server, though.
I'm currently leaning towards PostGres but am interested in hearing the pros and cons of both. The recent purchase of Sun by Oracle makes things a little more interesting.