Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Outdated release! Latest docs are Release 8.7: Change Database Port

   

If needed, you can change the default port used by the PostgreSQL instance for the Trifacta® platform. Please complete the following commands to avoid conflicts between versions.

If you are changing the port within the database, those changes must be applied through Postgres by a database administrator. To limit downtime, port number changes should be done at the same time in the platform and Postgres. For more information, please see the Postgres documentation included with your product.

By default, the ports for all databases are set to the default PostgreSQL database port. For more information on the default database ports, see System Ports.

Steps:

  1. Stop the Trifacta services. For more information, see Start and Stop the Platform.

  2. Stop Postgres. 

  3. Change the port number in Postgres. For more information, see the product documentation provided with your Postgres distribution.

  4. Start Postgres. Verify that it is listening on the new port number.
  5. You can apply this change through the Admin Settings Page (recommended) or
    trifacta-conf.json
    . For more information, see Platform Configuration Methods.
     Locate the following properties and modify as needed:
    1. Trifacta database:

      "webapp.db.port" = 5432;
    2. Jobs database:

      "batch-job-runner.db.port" = 5432;
    3. Scheduling database:

      "scheduling-service.database.port" = 5432;
    4. Time-based trigger database: 

      "time-based-trigger-service.database.port" = 5432;
  6. Save your changes and restart the platform.
  7. Verify that you can login and run a simple job. See Verify Operations.

  • No labels

This page has no comments.