Sold by: Lynxroute
Deployed on AWS
Free Trial
This product has charges associated with it for hardening, security configuration, and support.
PostgreSQL is the world's most advanced open-source relational database - a battle-tested, ACID-compliant SQL engine with JSON, full-text search, and extensions. Unlike bare PostgreSQL AMIs that ship with no password set, plaintext connections, and authentication you have to lock down yourself, this Lynxroute build is security baked in: scram-sha-256 auth required, a superuser password and a sample database generated at first boot, native TLS with a per-instance certificate, no trust auth anywhere, UFW firewall, and a CIS Level 1 hardened Ubuntu 24.04 LTS base.
It also bundles the pgAdmin 4 web UI: manage your database from any browser over HTTPS behind an nginx TLS perimeter, with an admin login generated at first boot.
A locked-down SQL database with a browser admin UI, safe from first boot. PostgreSQL license - fully auditable, no vendor lock-in.
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 auth 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
Web administration (pgAdmin 4):
- pgAdmin 4 web UI in server mode - browse schemas, run SQL, manage roles and backups from your browser
- Served only over HTTPS behind an nginx TLS perimeter on 443 (per-instance self-signed certificate; swap in your own with certbot)
- pgAdmin itself binds to 127.0.0.1 only - never exposed directly; the admin email and a random password are generated at first boot
- No new database port is opened - the UI is reached on 443, governed by your Security Group
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.
- Bundled pgAdmin 4 web UI: manage schemas, run SQL, and handle backups from any browser over HTTPS (nginx TLS perimeter on 443; pgAdmin binds to loopback, admin login generated at first boot). The world's most advanced open-source SQL database - ACID, JSON/JSONB, full-text search, replication. PostgreSQL license, no vendor lock-in.
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
Free trial
Try this product free for 5 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
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 |
|---|---|
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.
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
PostgreSQL 18.4 + pgAdmin 9.15 - adds the pgAdmin 4 web administration UI (server mode) behind the nginx TLS perimeter on 443 (/pgadmin4/); pgAdmin listens on loopback only, admin login generated per-instance at first boot. PostgreSQL 18.4 unchanged.
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); open 443 ONLY to the trusted IPs that will use the pgAdmin web UI
- Connect from an app server in the same VPC using the private IP, port 5432, and sslmode=require
- pgAdmin web UI: browse to https://<PUBLIC_IP>/pgadmin4/ and log in with the admin email + password from the credentials file (the certificate is self-signed by default)
The database requires scram-sha-256 password authentication, native TLS is enabled, and access to port 5432 is governed by your Security Group - never expose 5432 to the public internet. The pgAdmin 4 web UI is the only browser-facing component; it is served on 443 only, binds to loopback internally, and should likewise be scoped to trusted sources.
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
This product has charges associated with it for seller support. PostgreSQL on CentOS 10 is a robust, open-source relational database management system optimized for performance and reliability in cloud environments. It leverages the stability of CentOS 10, providing a secure and efficient platform for deploying scalable applications. With features such as advanced data types, support for concurrent connections, and powerful indexing, this AMI is perfect for handling complex queries and large datasets. It's ideal for developers and businesses looking to manage data-intensive applications, from web services to analytics. Streamline your database management and enhance your application's performance with this ready-to-run PostgreSQL instance, all while enjoying the benefits of seamless integration within the AWS ecosystem.
This product has charges associated with it for seller support. PostgreSQL on Ubuntu 24.04 LTS offers a powerful, open-source relational database management system, optimized for high performance, reliability, and scalability. Leveraging the stability of Ubuntu 24.04 LTS, this AMI simplifies the deployment of PostgreSQL in the EC2 cloud, enabling seamless integration with your applications. Benefit from advanced features such as JSON support, full-text search, and robust transaction processing capabilities. Ideal for developers and businesses needing a reliable database environment for web applications, analytics, and data-intensive workloads, this AMI allows for quick launch with pre-configured settings to expedite your project timelines. Utilize automated backups and scaling options to ensure your database grows with your business without compromising performance or security.
This product has charges associated with it for seller support. PostgreSQL on Amazon Linux 2023 offers a highly scalable, open-source relational database solution optimized for the AWS cloud environment. Deploying this AMI provides a secure, well-configured PostgreSQL installation, allowing you to focus on building applications without worrying about the underlying infrastructure. Leverage seamless integration with other AWS services, such as S3 for storage and Lambda for serverless computing, to enhance your application capabilities. The latest Amazon Linux 2023 enhancements ensure robust performance and security, while automatic updates keep your system running smoothly. Ideal for developers and enterprises looking to host applications ranging from data warehousing to web applications, this AMI simplifies PostgreSQL management and accelerates your time to market, making it a strategic choice for cloud-based database solutions.
This product has charges associated with it for seller support and pre-configured stack (Adminer) in it. Intuz PostgreSQL is a pre-configured, ready to run image for running PostgreSQL on Amazon EC2 and has Apache2, PHP, Adminer, PostgreSQL, and Scripts which make it easy for you to use PostgreSQL.
This product has charges associated with it, which includes support from Cloud Infrastructure Services. PostgreSQL Server and pgAdmin Web GUI on Ubuntu Server. Open-source relational database system 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.