Sign in
Sign in
or
Create a new account
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

PostgreSQL 9.5

Jetware | 170503-postgresql_9_5_6

Linux/Unix, Amazon Linux 2017.03.0 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

601 reviews
from G2

External reviews are not included in the AWS star rating for the product.

    Higher Education

Works well for my needs

  • March 02, 2017
  • Review provided by G2

What do you like best about the product?
Its simplicity and its ability to work with large datasets
What do you dislike about the product?
The default configuration is not optimal for the kind of work we do (large datasets and intensive queries). It requires significant tweaking.
What problems is the product solving and how is that benefiting you?
Access to large datasets and intensive queries.

    Danylo H.

A mature database management system

  • February 18, 2017
  • Review verified by G2

What do you like best about the product?
- very stable
- featurerich configuration, supports reconfiguring on fly
- lots of plugins (extensions)
- improving with each release
- ACID
- self-heal on start
- popular
- allows continuous backup and replication
- fast queries
- extended SQL (PG/SQL)
- fast restart
- has alot of GUI tools, has tuner program
What do you dislike about the product?
- had problems with WALs filling up disk space. After disk space is full, it is hard to start service - simply removing extra WAL files can make DB corrupt. So there should always be a method to quickly create free space on disk partition
- some configuration options can't be reconfigured on a fly (max_connections, listen_addresses)
- may be problematic to install on Windows (it involves creating dedicated user `postgres`, automatic, but our colleagues had problems with reinstalling)
- had problems with removing tablespaces
- had problems with table and index bloat (autovacuum not helping), requires periodic maintenance
-
What problems is the product solving and how is that benefiting you?
- managing large database for game data (using Hibernate ORM).
- data reliability
Recommendations to others considering the product:
- monitoring and alerting for disk size
- acompany with Barman backup manager
- use plugins/extensions (I recommend pg_repack plugin for database bloat redux)
- friend of mine recommends Amazon Data storage servers
- don't place indices on faulty disks - though they don't hold actual data, Postgres won't recreate them on device failure (I've placed indicies on a separate tablespace in instance store of EC2 server. After server reboot it was hard to start postgres)

    Hakim B.

A review of PostgreSQL

  • February 14, 2017
  • Review provided by G2

What do you like best about the product?
PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections.
What do you dislike about the product?
The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to.
What problems is the product solving and how is that benefiting you?
A website side-project to gather quotes.

    Telecommunications

PostgreSQL: A great opensource database

  • January 25, 2017
  • Review verified by G2

What do you like best about the product?
PostgreSQl is a wonderful piece of software that allows the easy storage, transfer and querying on spatial and non-spatial data. I particularly like, and extensively use, the PostGIS extension for spatial querying and representation with other software, notably QGIS. Its this seamless integration with other open source software that really makes PostgreSQL stand out. Finally, the backup methods through pg_dump are simple to use and ensure you can always take a backup before any major changes.
What do you dislike about the product?
I sometimes find it tricky to use from the command line and prefer using the pgAdmin III GUI for use. This is no fault of PostgreSQL though, merely my own shortcomings with operating databases from the command line.
What problems is the product solving and how is that benefiting you?
We are generating a data marketplace and looking for somewhere to store spatial data and querying this on the fly so we can send back the results to our users. Upon initially using MongoDB it was clear that this solution lacked the geospatial strength we needed so quickly switched to PostGreSQL.
Recommendations to others considering the product:
Go for it - you wont be let down! Its simple to set up, easy to administrate and provides a stable environment for storing and querying large amounts of spatial data

    Information Technology and Services

My experiences with PostgreSQL

  • January 25, 2017
  • Review verified by G2

What do you like best about the product?
PostgreSQl is a great piece of open source software that handles the storing, processing and extraction of large spatial and non -spatial datasets incredibly well. I wouldn't hesitate in recommending this piece of software. I particularly like, and regularly use, the PostGIS extension for spatial querying and representation in other software e.g. QGIS. Its the interactivity with other software that makes PostgreSQL stand out. Worth a mention is the backup facility of pg_dump - a quick and simple method to create those vital backups.
What do you dislike about the product?
Not much. I prefer using the GUI pgAdmin to navigate through PostgreSQL but that is not the fault of the software - merely my attachments to GUI's.
What problems is the product solving and how is that benefiting you?
We are building a marketplace that is storing and serving up geospatial data on our front end. This was initially done using MongoDB but its ha snow become apparent that Mongo has some issues with querying geospatial data on a large scale. Given the expertise PostgreSQL has with this - we are now starting to shift all our data holdings over so we can handle geospatial data with ease.
Recommendations to others considering the product:
Go for it - its easy to setup and start testing with data. Add the PostGIS extension to maximise your geospatial data.

    Higher Education

All that we need, at an acceptable price

  • January 20, 2017
  • Review provided by G2

What do you like best about the product?
I like the NoSQL key-value store (HSTORE) that works out of the box and binary JSON storage. This allows me to keep the SQL-based pipeline I have, yet venture into NoSQL land safely. And all of that for free.
What do you dislike about the product?
It had a bit of a learning curve to use properly.
What problems is the product solving and how is that benefiting you?
We are analysing large antibody datasets. Thanks to these analyses multiple vaccines against viral diseases have been developed.

    Internet

Fairly scalable, easy to configure, easy to maintain

  • January 13, 2017
  • Review provided by G2

What do you like best about the product?
I like that it is both lightweight and fast. It's pretty lean on resource consumption. Replication is easy to set up and pretty well documented by the Postgres Development Group. I like that it was easy to make changes to replication and access permissions without having to do a full restart of the database. I several times found my self impressed by how resilient the database was. Disk filled up? Add more storage and restart the database without data file corruption (YMMV). Your replication slave broke and you don't have the logs on disk for it to catch up? Blow it away, clone the master, and restart replication (don't use the postgres version in the AWS repo).
What do you dislike about the product?
In comparison to any other database technology that I've worked with, Postgres was easy to work with. "It wasn't implemented correctly", "replication was set up wrong", "the server capacity was misguessed when it was launched:" These are downsides to any technology where there is a general lack of knowledge. There's a simple way to avoid those problems: Hire a DBA, or experienced sysadmin and take their advice. There is problem with a lack of general knowledge when it comes to open source technologies combined with the fact experienced technologists all seem to have their own beloved biases. But those problems are not related to the technologies in use, but rather the people that use them.

Scalability never became an issue, but I haven't seen a lot of solutions for building hot-hot clusters, or putting multiple instances behind a connection manager for horizontal scalability, and trying to research multi node clusters will tell you how to set up synchronous/asynchronous master/slave replication at best or make you realize that a lot of the PG user community does not know the difference between high availability and scalability.
What problems is the product solving and how is that benefiting you?
Postgres made it easy to create redundant copies of data for both our front end web applications, and back end APIs servers. It allowed us to build applications with a high level of data redundancy in our production environments while simultaneously synchronizing that data to a DR environment. The addition of Postgres support in Amazon RDS was also a good indication of that some of the problems that we faced on standalone instances were quickly and easily solvable (as long as you are not using the Postgres packages available from Amazon, which are missing some key utilities).
Recommendations to others considering the product:
As with anything else try to accurately predict your requirements, and when in doubt supersize. Maybe hire someone with some experience to implement, and maintain it. If you hire an expert, take their advice.

    Erkan D.

PGSQL

  • January 10, 2017
  • Review provided by G2

What do you like best about the product?
- Open source and liberal Open Source license
- Big community
- Active development
- Partition, JSON, streaming replication support
- Performance
- Master-Master
- Transaction safe DDLs
What do you dislike about the product?
- Master-Master georeplication(BDR) not production ready yet.
- Missing Oracle-like stats reports(has 3rd party tools but not enough)
- Missing administration GUI(like Oracle's enterprise manager)
What problems is the product solving and how is that benefiting you?
We are using DB for telco data and have over 40 installations. Huge inserts and huge reports are used over PGSQL. Even default config on limited systems, PGSQL runs fluently and reliably. We also develop software products using PGSQL and without adding extra cost to our customers' bill, we get benefit with lower price.

    Anson A.

Postgres

  • December 21, 2016
  • Review verified by G2

What do you like best about the product?
open source, large community, some nice functions that get updated.
What do you dislike about the product?
parallel queries not available yet.
not as frequent w/ patches or new function releases
What problems is the product solving and how is that benefiting you?
RDMBS for reporting and meta info storage

    Rickert M.

Awesome open source database

  • December 20, 2016
  • Review verified by G2

What do you like best about the product?
I love the large feature set built into Postgres. In particular, range queries are a godsend for time-based applications. Full-text search functionality means I don't have to bother with an elastic search installation. There is also much additional functionality that can be gained via extensions such as postgis.
What do you dislike about the product?
Replication can be a pain to configure compared to other DBs. Hosted solutions like RDS takes care of this though.
What problems is the product solving and how is that benefiting you?
I used Postgres for a scheduling web app. Because range queries are built in, it's a lot less effort to query compared to MySQL. It's also more efficient. I also use the full-text search functionality for our built-in knowledge base, as well as the trgm extension to order search results.
Recommendations to others considering the product:
If regulations require you to encrypt data at rest, Postgres might be problematic. Postgres does not support database level encryption out of the box. Encryption at rest could possibly be achieved via full disk encryption. You can get this on medium sized RDS instances on Amazon. Otherwise, there is an extension for row level encryption.

showing 551 - 560