Hydrostatic pressure is the pressure exerted by an incompressible fluid (a liquid) at a given point, due to the weight of the fluid above it. Atmospheric pressure is the pressure exerted on a surface by the weight of the atmosphere (a compressible fluid) above it.
