Skip to main content
Version Next

High Availability Proxy Management

Below are the commands required to manage the high availability proxy in the PostgreSQL ecosystem:

Command Syntax
Terminal input
    pgsmart ha proxy [OPERATION] [Flags]

Operations:​

  • Status — Allows displaying the proxy status
  • Start — Allows starting the proxy service
  • Stop — Allows stopping the proxy service
  • Restart — Allows restarting the proxy service
  • Reload — Allows reloading the proxy service

Flags:​

  • -a, --agent=<agent> => Alias, hostname or IP of the server where the desired PgSmart Agent is installed
  • -h, --help => Help
Command Execution

Display proxy status​

Terminal input
    pgsmart ha proxy status

  • Select the desired PgSmart Agent (or Register a new Agent).

    Figure 1 - High Availability - Proxy - Status
    Figure 1 - High Availability - Proxy - Status

Start the proxy service​

Terminal input
    pgsmart ha proxy start

  • Select the desired PgSmart Agent (or Register a new Agent).

    Figure 2 - High Availability - Proxy - Start
    Figure 2 - High Availability - Proxy - Start

Stop the proxy service​

Terminal input
    pgsmart ha proxy stop

  • Select the desired PgSmart Agent (or Register a new Agent).

    Figure 3 - High Availability - Proxy - Stop
    Figure 3 - High Availability - Proxy - Stop

Restart the proxy service​

Terminal input
    pgsmart ha proxy restart

  • Select the desired PgSmart Agent (or Register a new Agent).

    Figure 4 - High Availability - Proxy - Restart
    Figure 4 - High Availability - Proxy - Restart

Reload the proxy service​

Terminal input
    pgsmart ha proxy reload

  • Select the desired PgSmart Agent (or Register a new Agent).

    Figure 5 - High Availability - Proxy - Reload
    Figure 5 - High Availability - Proxy - Reload