Sold by: Perimattic UK LTDÂ
Deployed on AWS
AWS Free Tier
This fully managed PostgreSQL solution delivers enterprise-grade database operations on AWS. Designed for seamless scalability and enhanced security, it provides advanced backup solutions, detailed query monitoring, and a user-friendly dashboard. Built for developers, analysts, and businesses, it ensures reliability, high performance, and simplified management.
Overview
This fully managed PostgreSQL solution is designed to deliver a secure, scalable, and high-performance database environment on AWS. With pre-configured settings optimized for both transactional and analytical workloads, it simplifies database management for businesses of all sizes. Key features include daily AMI backups and SQL export/import capabilities to Amazon S3, ensuring data security and recoverability. The platform also provides intelligent monitoring tools that offer actionable insights into server performance, query execution times, and system health, empowering users to resolve issues swiftly and optimize database performance. A user-friendly management dashboard enables effortless configuration, monitoring, and performance optimization, even for complex workloads. Designed with scalability in mind, the platform can accommodate business growth without compromising performance or reliability. Security is a priority, with advanced encryption, multi-level access controls, and compliance with industry standards to ensure that sensitive data is always protected. Whether for application development, transactional systems, or business intelligence, this PostgreSQL solution meets modern business demands with ease.
Highlights
- Optimized PostgreSQL: Deploy a high-performance, pre-configured PostgreSQL setup tailored for scalability and efficiency.
- Advanced Backup & Security: Daily AMI backups, seamless SQL export/import to Amazon S3, and enterprise-grade encryption for comprehensive data protection and recovery.
- Intelligent Query Insights: Monitor query execution and server performance with real-time insights, proactive alerts, and a user-friendly management dashboard.
Details
Sold by
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 24.04
Deployed on AWS
Unlock automation with AI agent solutions
Fast-track AI initiatives with agents, tools, and solutions from AWS Partners.
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.
Pricing
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.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
Dimension | Cost/hour |
|---|---|
t2.medium Recommended | $0.00 |
t3.micro AWS Free Tier | $0.00 |
t2.micro AWS Free Tier | $0.00 |
c6a.4xlarge | $0.00 |
r6id.16xlarge | $0.00 |
i3.8xlarge | $0.00 |
m6idn.8xlarge | $0.00 |
r5b.16xlarge | $0.00 |
g4ad.2xlarge | $0.00 |
i4i.metal | $0.00 |
Vendor refund policy
This product is currently offered free of charge on AWS Marketplace. Since there are no fees associated with the use of this AMI, refunds are not applicable.
Buyers may cancel use of the product at any time by terminating the associated Amazon EC2 instance.
For any questions or concerns, please contact: Perimattic.com Email: aws@perimattic.comÂ
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.
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:
- Automated PostgreSQL Setup: Includes a script that configures PostgreSQL with secure postgres user passwords and the option for remote access.
- Backup Functionality: A script for backing up all PostgreSQL databases and retaining them in /home/ubuntu/postgresql_backup.
- Backup Retention: Backup files older than 7 days are automatically deleted.
- Restore Functionality: A script to restore PostgreSQL databases in new or old database from previously created backups.
- Cron Job for Backups: A cron job has been set up to automatically backup PostgreSQL databases daily.
- Secure Password Storage: The PostgreSQL postgres user password is stored securely in /root/postgresql_postgres_password.txt
Additional details
Usage instructions
-
Launch an Instance From AWS Marketplace, select Continue to Subscribe then Continue to Configuration. Choose the recommended instance type (t2.medium or larger). Configure your VPC, subnet, and security group.
-
Set Security Group Rules Allow: SSH (22) from your IP to access the instance. PostgreSQL (5432) only from trusted sources if remote access is required.
-
Connect to the Instance After launch, connect via SSH: ssh -i <your-key.pem> ubuntu@<Public-IP-of-Instance>
-
Initial Setup On first login, the automated script will: Prompt you to set a PostgreSQL 'postgres' user password (or generate one automatically). Ask if you want to enable remote PostgreSQL connections. Prompt you to configure firewall settings.
-
PostgreSQL Access Once setup is complete, access PostgreSQL with: psql -U postgres The postgres user password is securely stored in: /root/postgresql_postgres_password.txt
-
Backups A daily cron job backs up all databases to: /home/ubuntu/postgres_backup/ Backup files older than 7 days are deleted automatically.
-
Restore from Backup To restore a database from a backup file, run: /home/ubuntu/restore_db.sh <backup-file.sql>
-
Verification Run psql -U postgres -c "\l" to confirm available databases. Check /var/log/postgresql/ for logs if troubleshooting is needed.
Support
Vendor support
For assistance, contact us at support@cro-digital.co.uk . Our team is ready to help with any inquiries or technical support needs.
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
Ubuntu Pro 24.04 LTS
By Amazon Web Services
Ubuntu Pro provides a secure supply chain, enhanced security, and automated hardening and compliance measures. Enjoy a decade of maintenance, including support for over 25,000 packages beyond the core operating system
Ubuntu Pro 24.04 LTS (ARM )
By Amazon Web Services
Ubuntu Pro provides a secure supply chain, enhanced security, and automated hardening and compliance measures. Enjoy a decade of maintenance, including support for over 25,000 packages beyond the core operating system
Ubuntu Pro 16.04 LTS
By Amazon Web Services
The official Ubuntu Linux optimized for AWS, with ten years of maintenance including an additional 23,000 packages beyond the main operating system, with easy access to compliance requirements (e.g. FIPS, CIS, DISA) and management tools
Ubuntu Pro 22.04 LTS for EKS 1.31
By Canonical Group Limited
Run Amazon Elastic Kubernetes Service (EKS) clusters on Ubuntu Pro and get the advantage of managed Kubernetes and the Ubuntu Pro security features.
Customer reviews
No customer reviews yet
Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.