A year or so ago the Aberdeen group looked at postgresql and said it is missing these key features. Their concerns have all been addressed with the latest version of Postgresql.
• Incremental and parallel backup/restore
Postgresql has a seperate transaction log
Postgresql has point in time recovery(via transaction log)
Postgresql has hot backup and restore
Commercial backup software support is still somewhat lacking. This is really up to those vendors. Netapp makes a decent alternative.
• Encryption (security)
Postgresql offers a variety of encryption options
• Deadlock detection
Automatic
• Row-level locking
MVCC is available
• Bit-mapped indexing (for large data warehouses)
Now available in 8.1, also, vastly improved improved performance on other forms of advanced indexing;
• A single GUI administrative interface
pgAdmin III – quickly getting better
• View update/insert/delete
Yes
Not mentioned but important:
• SQL standard compliant stored procedures.
Postgresql has procedures now, but they're not compliant with the standard syntax. This will be fixed in 8.1
• 2PC - Two phase commit
two-phase commit, which is another big thing for distributed application users;