Skip to main content

PostgreSQL

PostgreSQL is an open-source relational database for transactional applications, APIs, reporting tools, and internal software.

How PostgreSQL Runs On Moltern​

Moltern deploys PostgreSQL as a private service in the environment you select. It does not receive a public website URL. Applications and services connect through the workspace network with generated credentials.

Moltern also provides:

  • Persistent database storage.
  • Health and deployment status.
  • Protected connection details.
  • Guided attachment to applications and dependent services.
  • Capacity and billing review before supported size changes.

Before You Deploy​

Choose the environment that owns the data and review its available storage. Use separate database services for development, staging, and production when those environments must not share data.

Deploy PostgreSQL​

  1. Open Services.
  2. Search for PostgreSQL.
  3. Select the target environment.
  4. Review the requested capacity and storage allowance.
  5. Start the deployment and wait for the service to report Running.

Connect An Application Or Service​

Use Private service connections on the consuming workload. Select the PostgreSQL service and apply the connection. Moltern supplies the host, port, database name, username, and password to that workload without requiring the values in source control.

For a client that needs manual connection values, open the database service Settings and use Connection details. Sensitive fields are protected by the workspace connection-details password.

The standard PostgreSQL port is 5432, but always use the host and port displayed by Moltern.

Data And Deletion​

Database files remain in persistent workspace storage across normal restarts and service updates. Before deleting PostgreSQL:

  1. Export or back up data with PostgreSQL tools.
  2. Confirm no application or service still depends on it.
  3. Review whether the deletion flow will also remove stored data.
  4. Recheck Billing after cleanup and the next storage measurement.