Postgresql is one of the most feature reach and most versatile open source databases available. Great documentation, great performance and an engaged and useful community.
Pros
Highly performant and scalable
Feature rich
Reliable
Cons
No horizontal scaling; solvable with some plugins such as CitusData
