Installing a separate PostgreSQL server - Windows

This article provides a step-by-step guide for manually setting up a dedicated PostgreSQL server on a Windows machine for use with CloudM Migrate. The process includes installing PostgreSQL, modifying key configuration files for optimal performance, and installing and connecting CloudM Migrate to the PostgreSQL server.

Download and Install PostgreSQL Server

• Download PostgreSQL Server 17.4 from here.

• Launch the installer on the server where PostgreSQL will be hosted.

• Click Next to proceed through the setup wizard.

• Ensure the following components are selected for installation:

  • PostgreSQL Server

  • pgAdmin 4

  • Command Line Tools

• Click Next and provide a password for the PostgreSQL superuser (postgres).

• Specify the port (default: 5432).

• Complete the installation process.

Configure PostgreSQL for CloudM Migrate

After installation, modify the PostgreSQL configuration to optimize performance with CloudM Migrate.

Modify postgresql.conf

1. Open the following configuration file:

   C:\Program Files\PostgreSQL\17\data\postgresql.conf

2. Locate the section labeled # Add settings for extensions here and add the following line:

   max_connections = 1500

3. Save and close the file.

Modify pg_hba.conf

1. Open the authentication configuration file:

   C:\Program Files\PostgreSQL\17\data\pg_hba.conf

2. Add the following line at the bottom to allow all IP addresses:

   # Allow all IP addresses
   host    all    all    0.0.0.0/0    scram-sha-256

3. Save and close the file.

Restart PostgreSQL Service

To apply the changes, restart the PostgreSQL service:

1. Open Services on Windows.

2. Locate PostgreSQL 17 in the list.

3. Right-click and select Restart.

You should now be able to connect to the PostgreSQL server with CloudM Migrate.

Installing CloudM and connecting to the PostgreSQL server

1. Download the latest installer from the Migrate Release Notes page.

2. Launch the installer on the target server.

3. Agree to the terms and conditions, then click Next.

4. Configure the installation:

   • Select Advanced as the installation type.

   • Ensure Install Primary Service and Web Application is checked.
   • Decide whether you want to install the secondary service or not.
     • This will depend on whether or not you are creating a multi-server migration environment. You can find more information on the services here: Installation options

   • Ensure Use Existing PostgreSQL is checked.

   • Enter the hostname of the PostgreSQL server as the Postgre Host.
   • Enter 5432 as the Postgres Port unless a different port was specified during the installation.
     • You will also need to ensure the PostgreSQL server is accessible on that port from the migration server.
   • Enter a name for the Database, by default this is "poweredby".
   • Enter the User Name for the PostgreSQL server.
     • This will be postgres unless you have created a separate user for this.
   • Enter the Password for the PostgreSQL server.
     • This will be the password specified for the super user during the installation of PostgreSQL above.

   • Enter an email address and password (these will be your login credentials for the web interface).

   • Leave other settings as default.

5. Click Install to begin the installation.

After completing the installation, you can log in to CloudM Migrate using the credentials you specified. To do so, open a web browser on the same server and navigate to https://cloudm.local.