Both CREATE NETWORK INTERFACE and CREATE NETWORK ADDRESS seem to create a row in the network_addresses table. I wonder if there is really any difference between these commands.
In our product, we are trying to switch customer deployments from "Classic Load Balancing" to "Load Balanceing Policies". To configure classic load balancing, we created a NETWORK INTERFACE, and told the node to export on that network interface. For load Balancing policies, we create a NETWORK ADDRESS and add the address to a LOAD BALANCE GROUP.
In converting a Classic Load Balancing deployment to one using Load Balancing Policy, is there a need to delete the drop the NETWORK INTERFACE and create a NETWORK ADDRESS instead? They seem to be the same thing, and both look identical in the network_addresses table once created. So I can't even tell how it was created. In fact, if I create a NETWORK INTERFACE, I can drop it with DROP NETWORK ADDRESS, and vice versa.
This is in Vertica 23.4, though the original NETWORK INTERFACE may have been created in Vertica 10.1 or Vertica 11.1.
