Skip to content

Installing PostgreSQL

PostgreSQL is installed on a Host from the PostgreSQL tab of the Host form.

PostgreSQL tab of the Host form

You can install PostgreSQL manually, or let Muppy install it automatically when you create a cluster. This page covers the manual route.

  1. Open the Host form.
  2. On the PostgreSQL tab, click Install PostgreSQL. The PostgreSQL Installation Wizard opens.
  3. Pick a version and click Launch.

PostgreSQL Installation Wizard

When it finishes, click Refresh on the Host. Muppy lists the installed PostgreSQL versions.

Versions

Muppy installs PostgreSQL 9.5 through 18. The wizard defaults to the version set in Settings / PostgreSQL / PostgreSQL version, stored in the system parameter muppy_postgresql_base.default_postgresql_version. It ships as 18.

The pgvector extension is installed alongside PostgreSQL 15 and later.

Info

Installing PostgreSQL always installs the latest PostgreSQL client as well. Install an older server version and you still get the current client.

Danger

Installation does not create a cluster. Creating one is the next step.

Success

You can also skip this page and create a cluster straight away — Muppy installs whichever PostgreSQL version that cluster needs.