Listing Thumbnail

    PostgreSQL 18 - Hardened Self-Hosted SQL Database (TLS, SCRAM Auth)

     Info
    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 password authentication required, a superuser password and sample application database generated at first boot, native TLS enabled with a per-instance certificate, no trust authentication anywhere, UFW firewall pre-configured, and a CIS Level 1 hardened Ubuntu 24.04 LTS base. A locked-down, VPC-internal SQL database that is safe to run 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 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.

    Details

    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.

    Multi-product solutions

    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.
    Financing for AWS Marketplace purchases

    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.

    PostgreSQL 18 - Hardened Self-Hosted SQL Database (TLS, SCRAM Auth)

     Info
    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.

    Usage costs (5)

     Info
    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?

    Tell us how we can improve this page, or report an issue with this product.
    Tell us how we can improve this page, or report an issue with this product.

    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.

    Usage information

     Info

    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

    1. Launch instance (t3.medium recommended)
    2. SSH: ssh -i key.pem ubuntu@<PUBLIC_IP>
    3. Read credentials: sudo cat /root/postgresql-credentials.txt
    4. Open port 5432 in the Security Group ONLY to your trusted app-tier sources in the same VPC (never 0.0.0.0/0)
    5. 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

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 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.