Overview
This solution automates a PostgreSQL deployment, from the operating system to the database engine, thereby simplifying hours of configuration work. Abstracting away the underlying complexity, allows your development teams to deploy a PostgreSQL database in minutes, not days.
Deploy in Minutes, Not Days: Focus on building your applications rather than initial database configuration.
- Provides a foundation for developers that are less familiar with PostgreSQL configuration
- 5-minute automated deployment
- Automated setup process that eliminates human error and reduces time-to-market
Performance & Cost Benefits: Our team has tuned the Ubuntu and PostgreSQL stack to maximize efficiency and performance on Intel® Xeon AWS infrastructure.
- Superior database performance can enable you to use smaller, more cost-effective EC2 instances over the default open-source out-of-the-box PostgreSQL configuration
- Optimized resource utilization that can help reduce your cloud infrastructure spend
Considerations: While tuned configurations are superior to the open-source default settings, application teams should be aware that ongoing monitoring and additional adjustments may be necessary to fully support the specific requirements of their custom applications. We recommend regularly reviewing database performance and making environment-specific changes as needed to ensure optimal operation and compatibility with your unique workloads.
For configuration details, see User Guide link.
Highlights
- Deployment: Skip hours of manual configuration with AMI featuring Intel® tuned PostgreSQL, and performance best practices(ex: shared buffers).
- Higher Efficiency, Superior Performance, Lower Costs: Reduce your cloud infrastructure costs by increasing instance efficiency with tp to 2.4X performance improvements over the default open-source out-of-the-box PostgreSQL configurations.
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Vendor refund policy
It's free!
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
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
Initial release of PostgreSQL Optimized by Intel®
Additional details
Usage instructions
- SSH into the EC2 instance using the username ubuntu and your SSH Key
- ssh -i </path/to/your-key.pem> ubuntu@<your-instance-ip>
- Execute setup script
- /home/ubuntu/setup-postgresql.sh
-
Follow steps to configure the postgresql password
-
Validate using the following commands:
- psql -U postgres -h localhost -c 'SELECT NOW();'
- psql -U postgres -h localhost -c 'SELECT version();'
- psql -U postgres -h localhost
- Validate Logs
- sudo journalctl -u postgresql
- sudo tail -f /var/log/syslog
- Manage Services
- sudo systemctl status postgresql
- sudo systemctl stop postgresql
- sudo systemctl start postgresql
Resources
Vendor resources
Support
Vendor support
Use AWS EC2 support. Standard AWS EC2 support only. https://aws.amazon.com/contact-us/
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.