It's the easiest RDBMS for beginners with relatively simple syntax & very little administration required for basic apps. Review collected by and hosted on G2.com.
It is slower than MySQL and other non-RDBMS databases. Review collected by and hosted on G2.com.
Ease of use and functionality: being able to schedule tasks, create window functions. Review collected by and hosted on G2.com.
Finding small syntax differences between mysql and postgresql Review collected by and hosted on G2.com.
Simple interface, and easy for beginner (either for student or associate consultant) Review collected by and hosted on G2.com.
pip install are a lot, and it required one to do more research. Review collected by and hosted on G2.com.
High SQL standard coverage, feature rich and easy to use and deploy. Review collected by and hosted on G2.com.
If you need a database server, there are no real downsides. Point in time recovery is some work to set up. Review collected by and hosted on G2.com.
Postgres provide very amazing fields which other SQL database doesn't have like array field and json field to store data, postgres is very easy to integrate and very much easy to use too. Review collected by and hosted on G2.com.
Postgres installation with linux mint is bit difficult the documentation provided to install doesn't work properly with linux mint. Review collected by and hosted on G2.com.
easy to excecute the scripts,easy to find the database and tables, proper arrangement of views & tables. Review collected by and hosted on G2.com.
connecting to server , requires additional host names and details Review collected by and hosted on G2.com.
I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them via PostgreSQL is very easy. One good thing with PostgreSQL is that we can have multiple databases in single server and having different configurations for them. Overall we are most satisfied with PostgreSQL and their services. Review collected by and hosted on G2.com.
Ability to have multiple databases on single server. Having database users which are permission based Integration between multiple databases. Review collected by and hosted on G2.com.
PostgreSQL is an open-source database. It is an RDBMS. In our Organization, we are using PostgreSQL-9.4 and planning to upgrade it to 9.5 in future. PostgreSQL Database can be used for highly complex applications. It will reject the unauthorized connections to the database. In addition, The management panel for storage management is very useful. Review collected by and hosted on G2.com.
Configuring the Database in the local machine was a bit difficult. I don't find any good IDE's to work on it. PgAdmin's also there, I couldn't achieve the maximum speed. Because it's a web-based application Review collected by and hosted on G2.com.
- A very scalable data management system with powerful tools to exploit data
- A strong stability when execute complex request (trigger, ) and long term data archive
- A great stability for data storage, no data corrupted, no crash, it can store big data
- Open source and free, you can deploy PostgreSQL anywhere and anytime with sevral users as you want
- Very best support team with community Review collected by and hosted on G2.com.
- You must regularly execute autovacuum to insure performance
- It 'is a little complicated to implement logshipping master/slave clusterization
- Not as speed as Mysql for data selection (SELECT)
- Detailed documentation only available in English version Review collected by and hosted on G2.com.