We know that the pressure in a fluid (like water) is dependent on the depth. Consider this example:
For the first setup, solving the pressure at the bottom yields
$P_1 = \rho gh = 1000kg/m^3 \bullet 9.8m/s \bullet 1m = 9800Pa$
And from the definition of pressure, $P = F/A$, the fluid exerts a force on the piston equivalent to:
$F_1 = P_1A = 9800Pa\bullet 1m^2 = 9800N$
so the piston will exert a force of $9800N$ to maintain equilibrium.
Which should be reasonable since this is the actual weight of the water:
$W_{water}= 1000kg \bullet 9.8m/s^2 = 9800N$
For the second setup, solving the pressure at the bottom yields
$P_2 = \rho gh = 1000kg/m^3 \bullet 9.8m/s \bullet 1.5m = 14700Pa$
And
$F_2 = P_2A = 14700Pa\bullet 1m^2 = 14700N$
so the piston will exert a force of $14700N$ to maintain equilibrium.
Note that the water at each setup occupy the same amount of volume.
The question is: Is this assumption correct? If so, then how do the forces and pressures in the water arrange in such a way that it now requires more force to balance the water than its original weight? And how is setup 2 different from setup 3, where you have a solid mass of the same shape and weight?