Overview
This is a repackaged software product wherein additional charges apply for hardening, security configuration, and support.
WHAT IS POSTGRESQL
PostgreSQL is a powerful, open-source object-relational database management system, implemented in C as a robust multi-process server with multi-version concurrency control (MVCC). It offers fully ACID-compliant transactions, the SQL standard plus rich extensions, native JSON and JSONB, full-text search, window functions, common table expressions, materialized views, table partitioning, GiST/GIN/BRIN indexing, stored procedures in multiple languages, logical and streaming replication, and a mature extension ecosystem (the contrib modules pg_stat_statements, pgcrypto and uuid-ossp ship in the image). It speaks the standard wire protocol, so it connects from every language through libpq, JDBC and ODBC drivers. Data is persisted on disk with write-ahead logging and page checksums enabled. Running it yourself in your own VPC keeps your data inside your AWS account rather than a managed service. PostgreSQL license, no vendor lock-in.
WHAT THIS AMI ADDS
Security hardening:
- scram-sha-256 password authentication required - the postgres superuser password plus a sample application database and role are generated at first boot, never a default or empty password
- No trust authentication anywhere - every host connection in pg_hba.conf requires scram-sha-256
- Native TLS enabled at first boot with a per-instance self-signed certificate - no shared private key is baked into the image; clients connect with sslmode=require
- Listens for VPC-internal access only - port 5432 is governed by your Security Group, not exposed to the internet
- UFW firewall - SSH on 22 only; port 5432 governed by your Security Group
- fail2ban, AppArmor
- CVE scan - every image is scanned for vulnerabilities before release
OS hardening (CIS Level 1):
- CIS Ubuntu 24.04 LTS Level 1 benchmark applied via ansible-lockdown
- auditd, SSH hardening, Kernel hardening, IMDSv2 enforced
Compliance artifacts:
- SBOM - CycloneDX 1.6 at /etc/lynxroute/sbom.json
- CIS Conformance Report at /etc/lynxroute/cis-report.html
- CIS Tailored Profile at /usr/share/doc/lynxroute/CIS_TAILORED_PROFILE.md
Highlights
- PostgreSQL security baked in: scram-sha-256 auth required, superuser password and sample database generated at first boot, native TLS with a per-instance certificate, no trust authentication - unlike bare PostgreSQL AMIs that ship with no password set and plaintext connections you have to lock down yourself.
- CIS Level 1 hardened Ubuntu 24.04 LTS: auditd, fail2ban, AppArmor, SSH key-only, IMDSv2 enforced. CVE-scanned before every release. SBOM (CycloneDX) and CIS Conformance Report included.
- The world's most advanced open-source SQL database: ACID transactions, JSON/JSONB, full-text search, replication, and the contrib extensions. PostgreSQL license - fully auditable, no vendor lock-in.
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
Free trial
Dimension | Cost/hour |
|---|---|
t3.medium Recommended | $0.02 |
t3.large | $0.03 |
t3.small | $0.02 |
m6i.xlarge | $0.05 |
m6i.large | $0.03 |
Vendor refund policy
We do not offer refunds for this product. AWS infrastructure charges are billed separately by AWS and are not refundable by us.
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
PostgreSQL 18.4 - Initial release (June 2026)
- PostgreSQL 18.4 on Ubuntu 24.04 LTS (official PGDG packages)
- CIS Level 1 hardening applied (ansible-lockdown/UBUNTU24-CIS)
- CVE-scanned before every release
- scram-sha-256 password authentication required - superuser password and a sample application database generated at first boot
- No trust authentication - every host connection requires scram-sha-256
- Native TLS enabled at first boot with a per-instance self-signed certificate (sslmode=require)
- Data checksums enabled; contrib modules (pg_stat_statements, pgcrypto, uuid-ossp) included
- UFW firewall pre-configured (SSH on 22; 5432 governed by your Security Group)
- fail2ban, auditd, AppArmor pre-configured
- SBOM (CycloneDX 1.6) at /etc/lynxroute/sbom.json
- CIS Conformance Report (OpenSCAP) at /etc/lynxroute/cis-report.html
- IMDSv2 enforced
Additional details
Usage instructions
- Launch instance (t3.medium recommended)
- SSH: ssh -i key.pem ubuntu@<PUBLIC_IP>
- Read credentials: sudo cat /root/postgresql-credentials.txt
- Open port 5432 in the Security Group ONLY to your trusted app-tier sources in the same VPC (never 0.0.0.0/0)
- Connect from an app server in the same VPC using the private IP, port 5432, and sslmode=require
PostgreSQL is a VPC-internal database: it requires scram-sha-256 password authentication, native TLS is enabled, and access to port 5432 is governed by your Security Group. It is never meant to be exposed to the public internet.
Example (psql): psql "host=<PRIVATE_IP> port=5432 dbname=appdb user=appuser sslmode=require" psql "host=<PRIVATE_IP> port=5432 dbname=postgres user=postgres sslmode=require"
The postgres superuser password and the sample appdb/appuser credentials are saved to /root/postgresql-credentials.txt at first boot. A per-instance self-signed TLS certificate is generated at first boot; for production, replace /etc/postgresql/18/main/server.crt and server.key with a CA-signed pair (key owned by postgres, mode 600) and restart the service.
Resources
Vendor resources
Support
Vendor support
Visit us online: https://lynxroute.com
For PostgreSQL documentation: https://www.postgresql.org/docs/18/ For PostgreSQL community support and bug reporting:
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
