Listing Thumbnail

    PostgreSQL on Amazon Linux 2

     Info
    AWS Free Tier
    This product has charges associated with it for seller support. PostgreSQL on Amazon Linux 2 offers a robust, scalable, and secure relational database solution designed for performance and reliability in cloud environments. Built on the stable Amazon Linux 2 platform, this AMI ensures seamless integration with other AWS services, enabling easy management and scaling of your applications. It features automatic software updates and security patches, reducing operational overhead while enhancing security. Ideal for developers and businesses, this AMI supports complex queries and transactions, making it suitable for data-intensive applications like e-commerce systems, analytics platforms, or content management systems. Launch it in your EC2 instance and experience the full power of PostgreSQL in a highly optimized environment, fully managed by AWS's advanced infrastructure.
    Listing Thumbnail

    PostgreSQL on Amazon Linux 2

     Info

    Overview

    Play video

    This is a repackaged open source software wherein additional charges apply for extended support with a 24 hour response time.

    PostgreSQL on Amazon Linux 2 provides a robust, reliable, and scalable relational database management system designed for modern cloud applications. This AMI combines the performance and security of Amazon Linux 2 with the advanced features of PostgreSQL, ensuring optimal operation in your cloud environment.

    Key Features

    • Optimized Performance: Easily scale your database with features like connection pooling and performance tuning, ensuring high efficiency for your workloads.
    • Security: Benefit from built-in security features such as SSL connections and encryption support, helping to protect your data at rest and in transit.
    • Advanced SQL Compliance: Leverage PostgreSQL's extensive SQL compliance and advanced data types, including JSONB, for complex data handling and analytics.
    • Easy Integration: Seamlessly connect with other AWS services such as S3, Lambda, and CloudWatch for comprehensive application development and monitoring.

    Benefits

    • Cost-Effective: Utilize the flexibility of Amazon EC2's pay-as-you-go pricing model, allowing you to optimize costs as your needs grow.
    • High Availability: With options for replication and automated backups, ensure that your applications remain available and can quickly recover from failures.
    • Support for Extensions: Extend functionalities with PostgreSQL's support for an array of plugins and extensions, enabling customized database solutions that meet specific business requirements.

    Use Cases

    • Web Applications: Ideal for powering dynamic websites and applications that require a robust backend database.
    • Data Warehousing: Efficiently handle complex queries and analytics with PostgreSQL's advanced querying capabilities.
    • Microservices Architecture: Serve as a reliable data store within microservice architectures, ensuring data consistency and integrity.
    • Enterprise Applications: Suitable for enterprise-level applications needing good performance, reliability, and security.

    Deploy PostgreSQL on Amazon Linux 2 to take advantage of a powerful database solution that aligns perfectly with your cloud strategy, enhancing your operational agility while maintaining cost-effectiveness.

    Try our most popular AMIs on AWS EC2

    Highlights

    • PostgreSQL on Amazon Linux 2 offers a robust, scalable relational database platform tailored for enterprises. With the latest version of PostgreSQL deployed, users benefit from advanced features such as JSONB support, indexing improvements, and enhanced performance for complex queries. This AMI ensures compatibility with your existing applications while providing optimized access to AWS resources, streamlining the deployment process in the cloud.
    • This AMI provides a highly available and fault-tolerant PostgreSQL environment, enabling seamless application integration and high concurrency support. Automatic backups, scaling capabilities, and an easy management experience via AWS tools simplify database administration. Developers can utilize PostgreSQL for various workloads, from web applications to data analytics, ensuring a powerful back-end solution that can evolve with growing business needs.
    • Security is a top priority with PostgreSQL on Amazon Linux 2, offering built-in features such as encryption at rest and in transit. Regular updates and patches ensure a secure database environment. Coupled with AWS Identity and Access Management (IAM), users can define fine-grained permissions, ensuring robust access control for sensitive data. This AMI provides peace of mind while you focus on application development and optimization.

    Details

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    AmazonLinux 2

    Typical total price

    This estimate is based on use of the seller's recommended configuration (t2.large) in the US East (N. Virginia) Region. View pricing details

    $0.233/hour

    Pricing

    PostgreSQL on Amazon Linux 2

     Info
    Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covering your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.
    Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator  to estimate your infrastructure costs.

    Usage costs (589)

     Info
    • ...
    Instance type
    Product cost/hour
    EC2 cost/hour
    Total/hour
    t1.micro
    $0.07
    $0.02
    $0.09
    t2.nano
    $0.07
    $0.006
    $0.076
    t2.micro
    AWS Free Tier
    $0.21
    $0.012
    $0.222
    t2.small
    $0.07
    $0.023
    $0.093
    t2.medium
    $0.14
    $0.046
    $0.186
    t2.large
    Recommended
    $0.14
    $0.093
    $0.233
    t2.xlarge
    $0.28
    $0.186
    $0.466
    t2.2xlarge
    $0.56
    $0.371
    $0.931
    t3.nano
    $0.07
    $0.005
    $0.075
    t3.micro
    AWS Free Tier
    $0.07
    $0.01
    $0.08

    Additional AWS infrastructure costs

    Type
    Cost
    EBS General Purpose SSD (gp2) volumes
    $0.10/per GB/month of provisioned storage

    Vendor refund policy

    The instance can be terminated at anytime to stop incurring charges

    Legal

    Vendor terms and conditions

    Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Usage information

     Info

    Delivery details

    64-bit (x86) Amazon Machine Image (AMI)

    Amazon Machine Image (AMI)

    An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.

    Version release notes

    System Updates

    Additional details

    Usage instructions

    SSH to the instance and login as 'ec2-user' using the key specified at launch.

    OS commands via SSH: SSH as user 'ec2-user' to the running instance and use sudo to run commands requiring root access.

    Verify postgresql install version by running: sudo -u postgres psql -c "SELECT version();"

    Support

    Vendor support

    Email support for this AMI is available through the following: https://supportedimages.com/support/  OR support@supportedimages.com 

    AWS infrastructure support

    AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

    Similar products

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 AWS reviews
    |
    11 external reviews
    External reviews are sourced from G2  and are not included in the star rating for this product.
    Computer Software

    Very easy to use and works like you are running postgres on your own

    Reviewed on Oct 30, 2023
    Review provided by G2
    What do you like best about the product?
    Very easy to use and customisable like running on onprem env.
    What do you dislike about the product?
    Once your create a postgres with a port using cloud formation it is not possible to change it. You need to delete or detatch the instance from cloud formation and reattach it. Which is not great experience.
    What problems is the product solving and how is that benefiting you?
    Running postgresql locally or in onprem requires tremendous resource which is greatly reduced if i use cloud version.
    Vishwa R.

    Portable and Handy database

    Reviewed on Oct 25, 2023
    Review provided by G2
    What do you like best about the product?
    It comes with security features and tools required to run a production-grade database, making it a reliable and secure choice for hosting. It is quick to select and even more quicker to instatntiate. It is easy to implement as it comes with initutive settings which any developer can use. It is easy to integrate in most of the language, We in our organization used it with Java and golang.
    What do you dislike about the product?
    Nothing as of now, Its really superb db if you want to migrate your data in a hurry.
    What problems is the product solving and how is that benefiting you?
    When we used to run PostgreSQL on our in premis server then we need to patch tehe security updates manually. When ever tere is new version on Postgresql then we need to manually update oiur software. But this is not the case with PostgreSQL on Amazon Linux 2 as it comes with auto update feature and the security patches are automatically applied as soon as they arrive.
    Shubhi G.

    Simple & Best Solution for Scalable Database Requirement

    Reviewed on Oct 24, 2023
    Review provided by G2
    What do you like best about the product?
    Few features that made me love this open Source PostrgesSql on Amazon Linux 2 are
    High performance and scalability are required for large data volumes and transactions.
    The ability to offer a dependable environment for critical applications is reliability.
    provide dependable security features including SSL, encoding, and state-of-the-art authentication methods.
    Assistance with and information on the AWS Ecosystem
    What do you dislike about the product?
    I really dont see any such drawback, but few minor things such as frequent patches, Limited Support and Documentation can be another thing
    What problems is the product solving and how is that benefiting you?
    I needed to process and store millions of data points into my software, so I'm now using PostgeSQL to keep everything running smoothly.
    It is possible to manage large datasets effectively and to improve application responsiveness thanks to Amazon Linux 2's optimized performance and ability to scale both horizontally and vertically.
    PShriram T.

    Stable managed PosgresSQL database on linux server

    Reviewed on Oct 20, 2023
    Review provided by G2
    What do you like best about the product?
    It is simple to deploy PosgresSQL database on linux server. It is capable to handle large data volumes and transactions. It is reliable to use database for cloud based database use cases.
    What do you dislike about the product?
    I don't think anything is there which I dislike about PostgreSQL on Amazon Linux 2 excpet for the though that pricing of deployment could be more competative.
    What problems is the product solving and how is that benefiting you?
    I used PostgreSQL on Amazon Linux 2 to host our related database for our enterprise application. It help us by providing performant and scalable database for our application.
    E-Learning

    EC2 instance for automated testing pipelines runs very well with PostgreSQL

    Reviewed on Oct 13, 2023
    Review provided by G2
    What do you like best about the product?
    Having PostgreSQL running on a EC2 instance is actually pretty easy to have. The 9.2.24 version has a very stable behavior with a good performance.
    What do you dislike about the product?
    So far, I haven't experienced any downsides to having PostgreSQL on AWS. Maybe it comes down to making sure your SQL syntax is compatible with any other DB engines.
    What problems is the product solving and how is that benefiting you?
    Automated testing pipeline
    View all reviews