We do most of our development in Django, so Postgres is a natural fit. Every tool has its sweet spots, so you should use the tool that best fits the task.

For instance, Postgres is great for highly structured data (say, photos on a website). Riak shines when your data flexs more & you have a lot of it (say an activity stream).