PD AWS PostgreSQL lets you offer managed PostgreSQL databases on AWS through WHMCS, using AWS. It suits applications that need PostgreSQL, with the resource linked to the customer’s service.

Before you start

Install PD Modules for WHMCS first, connect the account that holds your licence, then install PD AWS PostgreSQL from its Store. Allow the administrator role that needs to use it.

You also need an AWS account with the permissions required for the chosen database service. Check the provider account’s permissions, available locations and capacity before enabling automatic provisioning.

Connect the account

Add the provider connection under System Settings → Servers, selecting this module for the server record. Assign the appropriate server group to the product. Keep provider credentials on the connection, separate from the product’s resource defaults.

Define what the customer receives

Create a product using PD AWS PostgreSQL and review its Module Settings and configurable options. Start with Region, Plan, Backing service, PostgreSQL version and Storage. Together these describe the resource requested when a service is provisioned; they are not just labels on the order form.

Choose Lightsail or RDS before choosing the plan. Firewall and resize options depend on the backing service.

Choose which client controls the product exposes. If you offer configurable options, check that their values match the module’s supported choices and that the defaults describe the service you intend to sell.

Put the service into use

Set the product’s automatic-setup behaviour deliberately. If you want provisioning after payment, select that option rather than leaving setup manual. Keep the normal cron running for subsequent status and usage updates.

Check the first service

Review the instance or cluster state, the connection details and the access controls. A pending resource is not ready for application connections.

Creating a real service creates provider resources and can incur provider charges. Review the configuration first; use your normal controlled test process for the first provisioning rather than making an order solely to browse the settings.

Explore the module

See the PD AWS PostgreSQL for WHMCS module page for the current product details.

AWS PostgreSQL task guides

• Connect an AWS account to PD AWS PostgreSQL in WHMCS
• Test the AWS connection for PD AWS PostgreSQL in WHMCS
• Configure a PostgreSQL database product in WHMCS
• Choose an AWS region for PD AWS PostgreSQL in WHMCS
• Choose a PostgreSQL database plan in WHMCS with PD AWS PostgreSQL
• Plan public or private PostgreSQL access with PD AWS PostgreSQL in WHMCS
• Investigate a pending PostgreSQL service in WHMCS with PD AWS PostgreSQL
• Choose RDS or Lightsail for PostgreSQL in WHMCS
• Start, stop or reboot a PostgreSQL database in WHMCS
• Take a PostgreSQL database snapshot in WHMCS
• Delete an unneeded PostgreSQL snapshot in WHMCS
• Check PostgreSQL CPU and usage graphs in WHMCS
• Plan PostgreSQL backup recovery for a WHMCS service