Steps to update Gateway IP for network pool in SDDC

Products

• VMware SDDC Manager

Issue/Introduction

• In SDDC Manager, the Network Pool in Network Settings only has the option to edit the IP Address Ranges.
• Editing the information that includes Network, VLAN ID, MTU, Subnet Mask and Default Gateway is not supported via GUI.

Resolution

Note: Please follow the below steps with caution. Ensure to take a snapshot of the SDDC Manager Virtual Machine before proceeding.

Follow the steps below to edit the Gateway for network pool. 

• Enter the postgres database:
  psql --host=localhost -U postgres -d platform


• Run the below command to expand the display:
  \x


• View the table vcf_network and note down the id for the respective network (for vSAN or vMotion) for which the gateway needs to be updated:
  select * from vcf_network;


• Run the command below to update the gateway:
  update vcf_network set gateway='<new_vSan_Gateway_IP>' where id='<vSAN ID>';
update vcf_network set gateway='<new_vMotion_Gateway_IP>' where id='<vMotion ID>';


• Exit the database:
  \q


• Check if the changes reflect on the SDDC UI.

Note: Ensure that the gateway is updated on the ESXi host for vMotion and vSAN network.