Listing Thumbnail

    PostgreSQL on Ubuntu 24.04 LTS

     Info
    Deployed on AWS
    AWS Free Tier
    This product has charges associated with it for seller support. PostgreSQL on Ubuntu 24.04 LTS offers a powerful, open-source relational database management system, optimized for high performance, reliability, and scalability. Leveraging the stability of Ubuntu 24.04 LTS, this AMI simplifies the deployment of PostgreSQL in the EC2 cloud, enabling seamless integration with your applications. Benefit from advanced features such as JSON support, full-text search, and robust transaction processing capabilities. Ideal for developers and businesses needing a reliable database environment for web applications, analytics, and data-intensive workloads, this AMI allows for quick launch with pre-configured settings to expedite your project timelines. Utilize automated backups and scaling options to ensure your database grows with your business without compromising performance or security.

    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 Ubuntu 24.04 LTS offers a robust and scalable relational database management system designed for reliability and performance. This AMI provides a comprehensive environment optimized for deploying PostgreSQL databases in the cloud, allowing you to harness the power of open-source database technologies on a highly stable and secure Ubuntu 24.04 operating system.

    Ubuntu 24.04 Key Features

    • Latest PostgreSQL Version: Utilizes the most current stable release of PostgreSQL, ensuring access to the latest features and improvements.
    • Ubuntu 24.04 LTS: Based on the long-term support version of Ubuntu, this AMI guarantees security updates and reliability for an extended period.
    • Easy Deployment: Simplifies the process of setting up a PostgreSQL instance in the Ubuntu 24.04 AWS EC2 environment with pre-configured settings for quick launch.
    • Scalability: Supports scaling out to meet growing data needs, making it suitable for both small applications and large-scale, enterprise-level databases.
    • Security: Incorporates best practices for security configurations, ensuring that your data is protected against unauthorized access.

    Ubuntu 24.04 Benefits

    • Cost-Effective: Leverage a powerful open-source database without the high licensing costs associated with commercial alternatives.
    • Performance Optimization: Pre-tuned for optimal performance on AWS Ubuntu 24.04 infrastructure, delivering fast response times for client queries.
    • Flexible Backup and Recovery Options: Utilize various backup strategies, from point-in-time recovery to simple hot backups, enhancing data resilience.
    • Active Community Support: Benefit from the vast support community of PostgreSQL, alongside access to extended support options for mission-critical applications.

    Ubuntu 24.04 Use Cases

    • Web Applications: Ideal for data-driven web applications requiring robust, reliable database management.
    • Data Warehousing: Use PostgreSQL to build efficient data warehouses that integrate with various ETL processes.
    • IoT Solutions: Manage large volumes of sensor or telemetry data from Internet of Things (IoT) devices with PostgreSQL's advanced data handling capabilities.
    • Business Intelligence: Analyze and report on data with powerful SQL capabilities, making it suited for BI applications.

    Deploy PostgreSQL on Ubuntu 24.04 LTS in your AWS environment today and empower your applications with a high-performing, open-source database solution.

    Try our most popular AMIs on AWS EC2

    Highlights

    • Experience the powerful combination of PostgreSQL and Ubuntu 24.04 LTS, offering a robust open-source relational database management system. This AMI is optimized for performance, delivering exceptional query speeds and reliability for handling large datasets. Benefit from a vast array of advanced features, including support for JSONB, full-text search, and custom data types, empowering data-driven applications and analytics.
    • Deploying PostgreSQL on Ubuntu 24.04 LTS in the AWS EC2 cloud ensures high availability and seamless scalability. The AMI includes automated configuration options, allowing you to get your database up and running quickly with minimal overhead. Leverage Amazon's infrastructure to handle traffic spikes and maintain performance without manual intervention, making it ideal for startups and enterprises alike.
    • With strong community support and comprehensive documentation, PostgreSQL on Ubuntu 24.04 LTS is well-suited for developers and system administrators. Utilize it for web applications, data warehousing, or transcoding complex queries across distributed systems. Leverage its extensibility and integration capabilities with various programming languages and frameworks, ensuring your database solutions align perfectly with your cloud architecture.

    Details

    Delivery method

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

    Latest version

    Operating system
    Ubuntu 24.04 LTS

    Deployed on AWS

    Unlock automation with AI agent solutions

    Fast-track AI initiatives with agents, tools, and solutions from AWS Partners.
    AI Agents

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    PostgreSQL on Ubuntu 24.04 LTS

     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 covers 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 (607)

     Info
    • ...
    Dimension
    Cost/hour
    t2.xlarge
    Recommended
    $0.28
    t2.micro
    AWS Free Tier
    $0.21
    t3.micro
    AWS Free Tier
    $0.07
    r6in.24xlarge
    $4.48
    m5.12xlarge
    $3.36
    r6a.large
    $0.14
    m7i-flex.xlarge
    $0.28
    r5d.4xlarge
    $1.12
    m4.xlarge
    $0.28
    r3.4xlarge
    $1.12

    Vendor refund policy

    The instance can be terminated at anytime to stop incurring charges

    How can we make this page better?

    We'd like to hear your feedback and ideas on how to improve this page.
    We'd like to hear your feedback and ideas on how to improve this page.

    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 'ubuntu' using the key specified at launch.

    OS commands via SSH: SSH as user 'ubuntu' 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.

    Product comparison

     Info
    Updated weekly

    Accolades

     Info
    Top
    25
    In Databases
    Top
    100
    In High Performance Computing
    Top
    25
    In Operating Systems

    Overview

     Info
    AI generated from product descriptions
    Database Management System
    Open-source relational database with advanced data handling capabilities supporting complex query processing
    Data Type Support
    Comprehensive support for JSON, full-text search, and custom data types with JSONB integration
    Security Configuration
    Incorporates robust security best practices with pre-configured protection against unauthorized database access
    Scalability Architecture
    Supports horizontal and vertical scaling for handling large datasets across small to enterprise-level database environments
    Version Management
    Utilizes the most current stable PostgreSQL release with long-term support Ubuntu 24.04 LTS operating system
    Operating System Type
    "Minimal Linux distribution based on CentOS Stream 10 with lightweight package configuration"
    Network Optimization
    "Enhanced Networking with Elastic Network Adapter (ENA) enabled for improved network performance"
    Security Configuration
    "SELinux enabled with root login disabled and SSH public key authentication"
    Cloud Compatibility
    "Cloud-init integrated with automatic root partition and filesystem extension during boot"
    Automatic Update Mechanism
    "Automatically updated at launch with latest CentOS Stream 10 security patches"
    Operating System Conversion
    "Provides in-place conversion tooling for rpm-based Linux distributions using Convert2RHEL utility"
    Extended Security Support
    "Offers security patches and updates until June 2028 for legacy Linux infrastructure"
    Infrastructure Consistency
    "Supports consistent management across physical, virtual, private cloud, public cloud, and edge deployments"
    Security Technology
    "Integrates advanced security technologies, controls, and certifications for comprehensive IT infrastructure protection"

    Contract

     Info
    Standard contract
    No

    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
    |
    2 external reviews
    Star ratings include only reviews from verified AWS customers. External reviews can also include a star rating, but star ratings from external reviews are not averaged in with the AWS customer star ratings.
    Roman Pryimuk

    Offers clear structure and reliable transactions but needs improvement in handling scalability

    Reviewed on Jun 11, 2025
    Review provided by PeerSpot

    What is our primary use case?

    We are working with Spring Boot  and everything related to this area, using a couple of modules from Spring Boot  such as security, data, and cloud. The most major aspect is that we work with relational database architecture.

    For the relational database, I use PostgreSQL on Ubuntu .

    I have been using PostgreSQL on Ubuntu  for all my commercial experience, which is around six or seven years.

    I use a relational database where objects and relations between them are needed, and where there is a specific structure. For example, if we have a parameter for our object, such as a user or an apple, we have specific size, weight, etc. Non-relational database is not about that; it's more about speed, but relational databases are specifically created for this task.

    The support for complex data types such as JSON and XML in PostgreSQL on Ubuntu adds technical behavior not related to typical relational databases. I have worked with JSON in PostgreSQL on Ubuntu, and it helps manage non-structured data effectively. You can also add an index for JSON and speed up searches, though it's a complex topic that requires deep knowledge of how indexes work.

    What is most valuable?

    The best feature of PostgreSQL on Ubuntu is its structure because it adds clarity and understanding when investigating a database. This structure makes it more understandable than non-structural data, which enhances readability and understandability for someone new to the project.

    I have utilized the advanced data replication features in PostgreSQL on Ubuntu. It provides a powerful mechanism for transactions, which is a huge achievement for relational databases.

    The community around PostgreSQL on Ubuntu is awesome and perfect. Any question or issue can be resolved with quick Googling, and there are many knowledgeable people, which is really beneficial.

    What needs improvement?

    Asynchronous replication will help in managing data distribution and seeing benefits, but I'm not certain as I have not worked with such tasks in PostgreSQL on Ubuntu. I've resolved similar things in non-SQL databases such as MongoDB , but I haven't attempted those functionalities in PostgreSQL on Ubuntu due to their complexity.

    For how long have I used the solution?

    I have been using PostgreSQL on Ubuntu for all my commercial experience, which is around six or seven years.

    What do I think about the stability of the solution?

    The main benefits PostgreSQL on Ubuntu brings are stability and reliability, especially for transactions in companies handling money, which is crucial.

    What do I think about the scalability of the solution?

    The main disadvantages I see in PostgreSQL on Ubuntu relate to handling scaling. Vertical scale can work sometimes, but as databases grow, resources can become inadequate, leading to the need for complex replication and sharding which not every specialist is aware of.

    Which solution did I use previously and why did I switch?

    I have worked with other relational databases apart from PostgreSQL on Ubuntu.

    How was the initial setup?

    In the very beginning of my learning path, I faced some difficulties in setting up PostgreSQL on Ubuntu, but now it's clear how it works. I know all the steps to make it work: creating databases, making users, providing rules, and creating tables.

    Which other solutions did I evaluate?

    The main differences of PostgreSQL on Ubuntu in comparison to other competitors involve ACID compliance, where non-relational databases have made strides. However, non-relational databases often have sharding available by default, making them more comfortable for dividing information. They also tend to be faster and fit for blob storage, but it's not the best way for storing files, as I prefer dedicated storage solutions such as S3  or Azure  Blob Storage.

    What other advice do I have?

    My advice for organizations considering PostgreSQL on Ubuntu is to thoroughly discuss their project needs, as it depends on their specific requirements. Spending time discussing future goals and project needs is crucial before making any decisions about a database, because changing databases during a project can be difficult and resource-intensive.

    The structure and design of the database as it stands are really nice.

    I haven't escalated any questions or issues regarding technical support with PostgreSQL on Ubuntu.

    I don't remember anything about PostGIS capabilities.

    On a scale of 1-10, I rate PostgreSQL on Ubuntu a 7.

    Naresh Modhwadia

    Handles high-demand database operations efficiently and offers significant cost savings

    Reviewed on Apr 17, 2025
    Review provided by PeerSpot

    What is our primary use case?

    We use PostgreSQL on Ubuntu  for storing our data related to high court cases.

    What is most valuable?

    The best advantage of PostgreSQL on Ubuntu  is its ability to fulfill all our requirements as an RDBMS . We frequently use various database-related operations such as storing, retrieving, and utilizing views and triggers. Its concurrency and connection handling are very efficient, especially since we have around 1,000 users.

    What needs improvement?

    We have not faced any errors, and for our purposes, PostgreSQL on Ubuntu is working perfectly. However, integrating AI features for analytical data generation might be beneficial as our processes are increasingly dependent on AI tools.

    For how long have I used the solution?

    We have been using PostgreSQL  since 2018.

    What do I think about the stability of the solution?

    I have found PostgreSQL on Ubuntu to be a very stable product.

    What do I think about the scalability of the solution?

    PostgreSQL on Ubuntu is very scalable with no restrictions.

    How are customer service and support?

    We have not utilized customer support, as we generally obtain information from publicly available sources.

    How would you rate customer service and support?

    Neutral

    How was the initial setup?

    The initial setup is quite easy to install, with the documentation being very well-organized. We do it ourselves without needing external technical assistance.

    What about the implementation team?

    We handle the installation ourselves.

    What was our ROI?

    We find the solution able to make savings of around 10% to 20%, depending on the solution being used.

    What's my experience with pricing, setup cost, and licensing?

    PostgreSQL on Ubuntu is free of cost. We are not purchasing anything additional.

    What other advice do I have?

    I would rate PostgreSQL on Ubuntu as a ten out of ten. The only suggestion for improvement is to add AI features.

    Which deployment model are you using for this solution?

    Hybrid Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Other
    View all reviews