SecureAnyCloud
Deployment guide

PostgreSQL

Overview

This page is the entry point for the SecureAnyCloud Hardened PostgreSQL 18, PostGIS & Postgres Extension AMIs listing on AWS Marketplace. The listing is a single product that offers several products and releases as separate software versions.

Subscribe once, and then choose the version you want from the Software version list at launch. Open that version's guide below for the full setup and connection walk-through.

What you get with every version:

  • An image built by SecureAnyCloud on a fully patched base, with the latest security updates applied at build time
  • First-boot setup that generates the database superuser and application passwords and a TLS certificate uniquely on each instance and writes them to a root-only file, so no default login exists and no two instances share a secret
  • Hourly metered pricing per EC2 instance type, the same for every version in this listing
  • A recommended instance type of m5.large
  • 24/7 SecureAnyCloud support

How to pick a version

  • Open the listing on AWS Marketplace. Choose View purchase options, and then choose Subscribe. One subscription covers every product and release in the listing, and the free trial starts with it.
  • When the subscription is active, choose Launch your software.
  • Choose One-click launch from AWS Marketplace, or Launch from EC2 Console for full control. In Version, choose the product and release you want. Each version is a separate software version, named <product> <release> on <operating system> - <date>, for example AgensGraph 2.18.6.0 on Ubuntu 24.04 - YYYY-MM-DD. The date is when that version was added to the listing.
  • Choose your Region, an instance type (m5.large is recommended), your EC2 key pair and a security group that opens the ports in the product's guide. Then choose Launch.
  • After launch, open the product's guide below for first login.

You can run several products from the same subscription. Launch one instance per product, each from its own software version.

The listing offers the following versions, newest release first:

  • AgensGraph: 2.18.6.0 on Ubuntu 24.04
  • Apache AGE: 1.6.0 on Ubuntu 24.04
  • IvorySQL: 5.6 on Ubuntu 24.04
  • MobilityDB: 1.3.1 on Ubuntu 24.04
  • ParadeDB: 0.25.9 on Ubuntu 24.04
  • Percona Server for PostgreSQL: 18.6 on Ubuntu 24.04
  • pg_duckdb: 1.1.1 on Ubuntu 24.04
  • pg_graphql: 1.6.2 on Ubuntu 24.04
  • PGroonga: 4.1.0 on Ubuntu 24.04
  • pgRouting: 4.0.2 with PostGIS on Ubuntu 24.04
  • PolarDB for PostgreSQL: 17.11.1.0 on Ubuntu 24.04
  • PostGIS: 3.6.4 on Ubuntu 24.04
  • PostgreSQL: 18.6 with pgAudit 18.0 on Ubuntu 24.04

Security model

Every version in this listing follows the same model:

  • No default login. Administrator passwords, database passwords and application secrets are generated on the first boot of each instance and written to a root-only file. No two instances share a secret.
  • Only the documented ports. Each guide lists the ports that the product needs. Open only those in your security group.
  • Database port closed to the internet. The listing's default security group opens SSH only. Reach the database port over an SSH tunnel, or allow it only from the networks of your applications, and never from 0.0.0.0/0.
  • Patched base. The operating system is fully patched when the image is built.
  • HTTPS. Each guide shows how to add a certificate on the instance or behind an Application Load Balancer with AWS Certificate Manager.

Choose your product

Each product has its own guide. The software version and operating system for each product are:

  • AgensGraph: AgensGraph 2.18.6.0 on Ubuntu 24.04
  • Apache AGE: Apache AGE 1.6.0 on Ubuntu 24.04
  • IvorySQL: IvorySQL 5.6 on Ubuntu 24.04
  • MobilityDB: MobilityDB 1.3.1 on Ubuntu 24.04
  • ParadeDB: ParadeDB 0.25.9 on Ubuntu 24.04
  • Percona Server for PostgreSQL: Percona Server for PostgreSQL 18.6 on Ubuntu 24.04
  • pg_duckdb: pg_duckdb 1.1.1 on Ubuntu 24.04
  • pg_graphql: pg_graphql 1.6.2 on Ubuntu 24.04
  • PGroonga: PGroonga 4.1.0 on Ubuntu 24.04
  • pgRouting: pgRouting 4.0.2 with PostGIS on Ubuntu 24.04
  • PolarDB for PostgreSQL: PolarDB for PostgreSQL 17.11.1.0 on Ubuntu 24.04
  • PostGIS: PostGIS 3.6.4 on Ubuntu 24.04
  • PostgreSQL: PostgreSQL 18.6 with pgAudit 18.0 on Ubuntu 24.04

How to tell which version you launched

The version you chose is shown on the instance's launch record in the EC2 console (AMI name and description) and in your AWS Marketplace subscription. On the instance itself, the login message after SSH names the product and its credentials file. Open the matching guide above for the rest of the walk-through.

Support

SecureAnyCloud provides 24/7 support for every version in this listing through the AWS Marketplace support channel. Raise a ticket through the Marketplace console, or email sales@secureanycloud.com.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Deploy on AWS

Launch Hardened PostgreSQL 18, PostGIS & Postgres Extension AMIs with 24/7 support from SecureAnyCloud.

View this image

Need Help?

Our support team is available 24/7.

sales@secureanycloud.com

Deploy on AWS