Overview
This is a repackaged open source software product wherein additional charges apply for technical support with a 24-hour response time. This AMI contains PostgreSQL 17 on Debian12 repackaged by Easycloud, fully configured for high-performance relational data storage and management.
PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. Version 17 brings significant improvements in query performance and memory management.
Debian12 (AL2023) provides a highly secure, stable, and high-performance execution environment for cloud workloads.
We uphold the core value of "Redefining open source value through performance and simplicity."
Guided by this commitment, this AMI is professionally repackaged by experienced engineers with a strict focus on Database Security and Backend Integration.
Why choose this AMI?
-
Contrib Modules Included: Comes pre-packaged with 'postgresql17-contrib', granting immediate access to essential official extensions like 'pg_stat_statements' for monitoring and 'uuid-ossp' for UUID generation.
-
Optimized for V17 Performance: Pre-configured to leverage PostgreSQL 17's advanced capabilities out-of-the-box, including the newly overhauled memory management for vacuum processes that drastically reduces system overhead.
-
Secure Admin Access: Retains 'peer' authentication for the local Unix socket, providing administrators with a secure, passwordless escape hatch for local maintenance via 'sudo su - postgres'.
-
Enterprise Structure: Adheres strictly to standard Linux file hierarchies for configurations, logs, and data, simplifying backend management and automated deployments via tools like Ansible or Terraform.
Highlights
- Extensions Pre-loaded: Includes the 'contrib' package out-of-the-box, granting instant access to vital tools like 'pg_stat_statements' and 'uuid-ossp'.
- Version 17 Ready: The database cluster is pre-initialized and natively integrated with systemd for automatic startup.
- Expert Support: Backed by comprehensive documentation and fast, professional technical assistance.
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
- ...
Dimension | Cost/hour |
|---|---|
t3.medium Recommended | $0.04 |
t2.micro | $0.04 |
t3.micro | $0.04 |
r6i.metal | $0.98 |
g7e.24xlarge | $0.68 |
g4dn.2xlarge | $0.29 |
inf2.8xlarge | $0.39 |
c4.8xlarge | $0.39 |
c4.large | $0.12 |
g6f.2xlarge | $0.29 |
Vendor refund policy
No refunds. Cancel anytime.
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
Update to the latest version
Additional details
Usage instructions
Connection Methods:
Access the instance via SSH using the 'admin' user. Use 'sudo' to run commands requiring root privileges. To switch to the root user, use 'sudo su - root'.
Install Information
- Operating System: Debian 12 (Bookworm)
- PostgreSQL Version: 17
- Port: 5432
- Superuser: postgres
- Data Directory: '/var/lib/postgresql/17/main/'
- Config Files: '/etc/postgresql/17/main/postgresql.conf' and '/etc/postgresql/17/main/pg_hba.conf'
- Log Directory: '/var/log/postgresql/'
Usage Instructions
-
Local Admin Access: Connect locally by running: 'sudo -u postgres psql'
-
Manage Service: Use 'sudo systemctl start/stop/restart postgresql@17-main' to control the database daemon.
-
Enable Remote Access:
By default, PostgreSQL only allows local connections. To enable remote access, complete these exact steps:
-
Step 1: Open '/etc/postgresql/17/main/postgresql.conf', find the 'listen_addresses' parameter, uncomment it, and set it to: listen_addresses = '*'
-
Step 2: Open '/etc/postgresql/17/main/pg_hba.conf', scroll to the very bottom, and append this exact line: host all all 0.0.0.0/0 scram-sha-256
-
Step 3: Apply the configuration changes by running: sudo systemctl restart postgresql@17-main
-
Step 4: AWS Firewall: Go to your AWS Console and ensure the EC2 Security Group has an Inbound Rule allowing TCP Port 5432.
Firewall Configuration
-
SSH (Port 22): Required for initial system access.
-
PostgreSQL (Port 5432): Required for remote database clients (e.g., pgAdmin, DBeaver) or application servers to connect.
-
Security Recommendation: For production environments, strictly limit access to ports 22 and 5432 to trusted IP addresses only via AWS Security Groups.
Support
Vendor support
Should you encounter any issues while using the system, please do not hesitate to contact us via email at: support@easyclouds.io ,Thank you!
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.