The invention relates to an ester hydrogenation catalyst and a preparation method and application thereof. The catalyst contains 5-30% (wt) of an active ingredient, 0.1-2.5% (wt) of an assistant and a carrier, wherein the active ingredient is a Cu-Ag alloy; the assistant includes one or more of B, C, N, F, Cl or Br; the carrier is a composite oxide of r-Al2O3 and SiO2, the mass ratio of Cu to Ag is (0.1-10):1 and the mass ratio of Al to Si in the carrier is (0.1-2):1. The catalyst is prepared by adopting a coprecipitation method, and is mainly applied to reaction of ester-hydrogenated alcohol. Compared with the prior art, the ester hydrogenation catalyst has the characteristics of high activity, high orientation selectivity and good stability, and is especially suitable for industrial application.