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
Features and programs
Financing for AWS Marketplace purchases
Pricing
- ...
Dimension | Cost/hour |
|---|---|
t3.medium Recommended | $0.05 |
t3.micro | $0.05 |
x8aedz.metal-12xl | $0.05 |
p2.8xlarge | $0.05 |
trn1.32xlarge | $0.05 |
p2.xlarge | $0.05 |
t3a.xlarge | $0.05 |
r4.xlarge | $0.05 |
r5.12xlarge | $0.05 |
r5ad.4xlarge | $0.05 |
Dimensions summary
Top-of-mind questions for buyers
Vendor refund policy
For any questions or concerns, please contact: Perimattic.com Email: aws-support@perimattic.com
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
Security and maintenance refresh.
- Rebuilt from a current Ubuntu 24.04 base image and fully patched, addressing the operating-system vulnerabilities reported by the AWS Marketplace security scan.
- Built by an automated, reproducible EC2 Image Builder pipeline rather than by hand, so future security refreshes ship on a monthly schedule.
- Hardened: SSH password authentication and direct root login are disabled, SSH host keys are generated per instance on first boot, and no credentials, shell history or build-host identity is present in the image.
- The database listens only on localhost until remote access is explicitly enabled during first-boot setup.
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.