Find the answer to your question

How to Use gpexpand Working with One Host

The below document gives an example of how to expand the segments using one host and also explains a balanced and in-balance method of expanding the cluster or segments.

Procedure

Explained below is the example of how to do about.

Scenario 1. In-balance method.

Here I have two segment servers in the configuration ( sdw1 / 2 ) Using gpexpand, I added a third host (sdw3) to the segments and the mirror of sdw3 was passed on to sdw1 ( making sdw1 overloaded which is an in-balance state )

Here I had two segments in the configuration ( sdw1 / 2 ) , Renamed the mirror directory , Using gprecoverseg I moved the mirror to the new host ( sdw3) Using gpexpand I added a third host (sdw3) to the segments and the mirror of sdw3 was passed on to sdw1 ( this helped in balancing the workload ) .