← Back to PDM Help

PostgreSQL Installation

How to install PostgreSQL Server for use with SavantPDM

SavantPDM uses PostgreSQL as its database server. This guide will help you download and install PostgreSQL on your system.

Single User vs. Multi-User Setup:

  • Single user (e.g., Maker subscription): PostgreSQL can be installed directly on your own computer.
  • Multi-user (e.g., MakerPro, Team, Professional, Enterprise): PostgreSQL should be installed on a server that all PCs and/or Macs in your organization have network access to.

On This Page

Installing on macOS

There are several ways to install PostgreSQL on macOS. We recommend using the official installer from EDB (EnterpriseDB).

Option 1: EDB Installer (Recommended)

  1. Visit the official PostgreSQL download page for macOS
  2. Download the installer for your macOS version
  3. Run the installer and follow the on-screen instructions
  4. When prompted, set a password for the postgres superuser account
  5. Keep the default port (5432) unless you have a specific reason to change it
  6. Complete the installation
Download PostgreSQL for macOS

Option 2: Homebrew

If you use Homebrew, you can install PostgreSQL with:

brew install postgresql@16

Then start the PostgreSQL service:

brew services start postgresql@16

Installing on Windows

For Windows, we recommend using the official installer from EDB (EnterpriseDB).

Installation Steps

  1. Visit the official PostgreSQL download page for Windows
  2. Download the installer (choose the latest version)
  3. Run the installer as Administrator
  4. Select the components to install:
    • PostgreSQL Server - Required
    • pgAdmin 4 - Recommended (graphical management tool)
    • Stack Builder - Optional
    • Command Line Tools - Recommended
  5. Choose an installation directory (default is usually fine)
  6. Set a password for the postgres superuser account
  7. Keep the default port (5432) unless you have a specific reason to change it
  8. Select the default locale
  9. Complete the installation
Download PostgreSQL for Windows

Important: Remember the password you set for the postgres user. You will need it to configure SavantPDM.

After Installation

Once PostgreSQL is installed:

  1. Verify the installation by opening pgAdmin or connecting via command line
  2. Note your connection details:
    • Host: localhost (or server IP address for multi-user setups)
    • Port: 5432 (default)
    • Username: postgres
    • Password: (the password you set during installation)
  3. Configure SavantPDM with these connection details in Admin Settings

For multi-user setups: Ensure that the PostgreSQL server is configured to accept connections from other machines on your network. This may require adjusting the pg_hba.conf and postgresql.conf files, and potentially your firewall settings.

Need More Help?

If you have questions or need assistance, please visit our Contact page to get in touch with our support team.

← Back to PDM Help