PostgreSQL on Ubuntu 16.04
Supported Images | 20210403Linux/Unix, Ubuntu 16.04 LTS - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Works just fine
What do you like best about the product?
For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software.
What do you dislike about the product?
Nothing, it works just fine for my needs.
What problems is the product solving and how is that benefiting you?
storing and access various large set of configuration settings, and snapshotting states of a system
- Leave a Comment |
- Mark review as helpful
Cost Effective alternative Databse
What do you like best about the product?
It's open source software and a large community that supports the incredible features that the database offers
What do you dislike about the product?
Nothing yet! Replication could be improved
What problems is the product solving and how is that benefiting you?
Most solutions do not need a heavy-weight database like Oracle or MS SQL; PostgreSQL offers a very convenient and powerful database that pack a lot of features.
Recommendations to others considering the product:
Do a cost / benefit analysis - this is fundamental for any new customer engagement solution that uses your product. A database is the core of any software application and you must understand and search out the issues and requirements that face the customer. Every implementation is unique and needs to be looked at holistically - architecture, security, performance, disaster recovery, reliability etc
Postgres review
What do you like best about the product?
PostgreSQL interfaces nicely with Django.
What do you dislike about the product?
I have no specific complaints for PostgreSQL.
What problems is the product solving and how is that benefiting you?
It was the data store for a Django based web UI.
A very convenient DBMS!
What do you like best about the product?
I like the ease of use, that it supports almost all sql contructs, free, and suitable to most projects, small or large
What do you dislike about the product?
The UI could be updated, but for a database server the current does the job and more
What problems is the product solving and how is that benefiting you?
It helps me a lot with data queries and exporting data from analytics solutions to the database and then to other solutions, or just me querying the data creatively!
Recommendations to others considering the product:
Try it, you won't regret it and it's for free!
Works well for my needs
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.
A mature database management system
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
- 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
-
- 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
- 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)
- 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)
A review of PostgreSQL
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.
PostgreSQL: A great opensource database
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
My experiences with PostgreSQL
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.
All that we need, at an acceptable price
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.
showing 491 - 500