Sold by: Perimattic ManageStacks
Deployed on AWS
Production-ready PostgreSQL with full root access, automated backups, security hardening, and performance tuning on AWS.
Overview
This fully managed PostgreSQL solution delivers a production-ready, hardened database server on AWS, built on Ubuntu 24.04 LTS. Every instance is pre-configured with security best practices, performance optimizations, and automated operations so you can focus on your application, not infrastructure.
Key Features
Automated Setup and Configuration On first login, an interactive setup script guides you through PostgreSQL configuration. It securely generates and stores credentials, configures authentication methods, and sets up firewall rules - all within minutes. No manual database administration required.
Built-in Backup and Recovery A pre-configured daily cron job automatically backs up all databases. Backups older than 7 days are automatically purged to manage disk space. The included restore script lets you recover any database from a backup file with a single command. For additional resilience, you can export SQL dumps to Amazon S3 or integrate with third-party backup tools.
Security Hardened The instance ships with security best practices applied out of the box: secure credential storage with root-only access, UFW firewall pre-configured to allow only SSH (22) and PostgreSQL (5432) from trusted sources, and the latest security patches applied. PostgreSQL is configured with md5 authentication and restricted pg_hba.conf by default.
Performance Optimized Shared buffers, work memory, effective cache size, and connection limits are tuned for the selected instance type. Whether you are running a small development database on t2.medium or a production workload on m5.xlarge, the configuration scales with your instance size.
Monitoring and Troubleshooting PostgreSQL logs are available for quick troubleshooting. You can integrate with CloudWatch, Grafana, or Prometheus for advanced monitoring and alerting. pg_stat_statements is pre-enabled for query performance analysis.
Use Cases Web applications and API backends requiring reliable relational data storage SaaS and multi-tenant applications with row-level security and schema isolation Geospatial applications using PostGIS extension for location-based queries Data warehousing and analytical workloads with advanced SQL capabilities Development and staging environments with production-like configuration Microservices architectures requiring ACID-compliant data persistence
Getting Started Launch the AMI from AWS Marketplace on your preferred instance type SSH into your instance and follow the interactive setup wizard Your PostgreSQL server is production-ready with backups, firewall, and tuning configured automatically
For a detailed getting-started guide, architecture overview, and backup/restore runbook, visit our documentation at <www.perimattic.com >.
Ready to Get Started?
Book a free setup consultation with our team to discuss your specific requirements, custom configurations, or migration needs. Schedule a call at https://cal.com/gaurav-pareek-perimattic/marketplace-setup-consultations or email us at aws-support@perimattic.com .
Support
Managed and supported by Perimattic, a cloud infrastructure company with 13+ years of experience serving global clients. We offer free setup assistance, custom integrations, infrastructure consulting, and 24/7 support.
Highlights
- Full Root Access PostgreSQL: Complete OS-level control to customize extensions like PostGIS, tune kernel parameters, configure replication modes, and manage pg_hba.conf without restrictions.
- Automated Daily Backups with 7-Day Retention: Pre-configured cron job backs up all databases daily, auto-purges older backups, and includes a one-command restore script. Export to S3 for additional resilience.
- 24/7 Expert Support by Perimattic: 13+ years of cloud infrastructure expertise with free setup assistance, instance sizing guidance, migration planning, and dedicated support at aws-support@perimattic.com.
Details
Sold by
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 24.04
Deployed on AWS
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
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.05 |
t2.large | $0.05 |
t2.xlarge | $0.05 |
t3.medium | $0.05 |
t3.large | $0.05 |
t3.xlarge | $0.05 |
m5.large | $0.05 |
m5.xlarge | $0.05 |
Vendor refund policy
For any questions or concerns, please contact: Perimattic.com Email: aws-support@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.
Thank you for subscribing. Your instance is ready to go!
Need Support or Customization? Whether you're facing setup issues or need custom features, Perimattic's expert team is here to help:
Email us: aws-support@perimattic.com WhatsApp: +91-92142 66896 Learn more: <www.perimattic.com >
We offer: Free setup assistance Custom development & integrations Infrastructure consulting Automation & AI solutions With 13+ years of experience serving global clients, we ensure your deployment runs smoothly and scales with your needs.
Let's build something great together!
Resources
Support
Vendor support
Support by Perimattic
Perimattic provides 24/7 support for all AWS Marketplace products. Our team has 13+ years of cloud infrastructure expertise serving global clients.
Contact Channels: Email: aws-support@perimattic.com WhatsApp: +91-92142 66896 Website: <www.perimattic.com >
What We Help With: Initial setup and configuration assistance (free) Troubleshooting connectivity, performance, and backup issues Custom development and integrations Infrastructure consulting and architecture review Migration planning from other solutions Automation solutions and scaling guidance
Instance Sizing Guidance: t2.medium or t3.medium: Development environments, small applications m5.large: Production workloads with moderate traffic m5.xlarge: High-traffic production deployments and larger datasets
For workload-specific sizing recommendations, contact our team for a free consultation.
Refunds and Issues: If you experience any issues or need to request a refund, contact us at aws-support@perimattic.com and we will respond promptly.
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
Production-ready PostgreSQL with full root access, automated backups, security hardening, and performance tuning on AWS.
Perimattic provides Vector Database Development Services to build high-performance AI search and Retrieval-Augmented Generation (RAG) applications on AWS. We design, deploy, and optimize scalable vector databases that power semantic search, enterprise knowledge bases, AI agents, and generative AI solutions.
Perimattic designs, deploys, and optimizes vector databases on AWS for semantic search, RAG pipelines, and AI agent applications - serving mid-market to enterprise engineering teams.
Production-ready ClickHouse with full root access, automated backups, and security hardening - a high-performance columnar database for real-time analytics on AWS.
Production-ready Neo4j with full root access, automated backups, and security hardening - a self-hosted graph database for knowledge graphs, recommendation engines, and network analysis on AWS.
Production-ready Neo4j with full root access, automated backups, and security hardening - a self-hosted graph database for knowledge graphs, recommendation engines, and network analysis on AWS.
Production-ready Neo4j with full root access, automated backups, and security hardening - a self-hosted graph database for knowledge graphs, recommendation engines, and network analysis on AWS.
Production-ready ClickHouse with full root access, automated backups, and security hardening - a high-performance columnar database for real-time analytics on AWS.
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.