PostgreSQL provides many advantages, but it has a few drawbacks as well. Some of which are:-

1.PostgreSQL is less popular compared to other databases like MySQL or oracle.

2.PostgreSQL is relatively slower compared to MYSQL.

3.PostgreSQL is open source, so it's hard to get a quick fix for any bug/issue.

4.Many open-source applications support mysql, but not PostgreSQL.

5.setting up the replication in PostgreSQL is relatively complex.