(redis缓存更新策略)postgres 9.4.1 && redis 3.7.0 && redis_fdw_REL9_4_STABLE
首先下载redis_fdw,这里要注意下载的版本。(https://github.com/pg-redis-fdw/redis_fdw)
一开始,我下载了REL9_4_STABLE_pre2.8版本,安装成功后只能进行查询,不能增删改,联系上德哥后才知道未开发写接口,于是我换成了REL9_4_STABLE版本,终于成功了。。。
hiredis在redis的目录下是有的,可以直接拷贝到postgres的包路径下。(redis_fdw-1.0.0下面是hiredis文件)
首先安装hiredis
cd /redis_fdw-1.0.0
cd hiredis
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWsAAABJCAYAAAD7VQfxAAAABHNCSVQICAgIfAhkiAAAGspJREFUeF7tXXesFUd3H1qopnz08nCQCKGKyCFUA/5M78X00IvMHzSBgH8MggilgEHwiSKwEQQQTRARgkIQvXew6WC6IXQIvTOZ3+C5zN07szt7X+He985KT7Bnzpzym7Nnp92dbIwxLv7oIgQIAUKAEEhgBLInsG1kGiFACBAChMAfCFCyplAgBAgBQiAJEMjOOWfqLwnsDWUi/Moql96On9PveHS3bduWnTp1ir169YqdPHmStWrVKqbZgniaNm3K1q9fzx49esSePn3Kjhw5wvr27RsjJ4gQ1v6w/EH6Xcttem30MHJVLPnVadeuHbty5Ypk6dSpE7tw4YIfe1RZosSqs8GJwiiAQ0ZLmL8ge/Lnz89nzpzJ79y5wx8+fMgXLFjA8+TJY7Q/SFYi+Q1b0sretJITDz5hddeoUUO2pUi2sh2bNWsm76tWrRppUxce6N2xYwdv2LAhz5s3L69SpQrfvHkznzBhgjE2bL6FtT8sv01vWLpNr42eVvKVnBkzZvCFCxdKbGfPns3nzZsXCmclJ63sDetfUvInGlh+9mTLlo1v2rSJL168mJcrV46XLFlS3k+ZMiWuQEm0BvPzPYytaSUnjM54H7758+fzMWPGRLXfuHHjoh5+F55p06ZxxIduc0pKikz8Yfz4nNglkp1BOBw/fpz37t1bYnv27FnetWvXUDjHGy9hMMp0vEGNAodxlShRgq9YsYKLYSa/d+8eHzVqVKRxRo8ezS9fvszfvHkj/9XLFGBBPFKJ4dIBR0AcPnyYZ8+ePaIbPbBLly5FBYouxtRg8GXu3LnS1hcvXvDHjx/LpC+G3xE5kNGvXz9+8eJF/vr1a37u3DkuhtUxARnklx6UNgwNbkuS1/aOHTtyMbznYrqAX716lQ8cODCGR7WXt65+H2SzSbdJbv/+/fn58+clPmiDAQMGGO32s+XMmTO8WrVqUX6gJ3369OkIzYXHpKNYsWL8wYMHRoxM/MrHRo0a8V27dvHnz5/LWF+1apWMf72O3mY2WUqerd1RLqYT+NGjR2WbXrt2jQ8dOjTGXhecg+xxiXmvf16/KleubAvVCN1bJ+jeFmuoF9bmIF1JX+4HlnIOPBs2bOA9e/bkRYoU4aVKleJz5syRQYW3KxJZvXr1OKYo6tevz8X8Fe/Ro0ck6Fx4dF02UNetWycTAsrr1q3Lb968yVeuXMnfvn0bE+DgsfmGBxG9N/iRM2dOXrx4cd65c2e+devWiBzURSJq0KCB9Av64GfLli3j9suGoYvveKjxMDdv3pwXKFCA48H5+eefQ/nt2l423HS6mEOWeAAX4AOc0O62urY2ffbsGc+XL5/0Y+/evXz37t1Snph3jvjmwmOSP3ny5EicmspNNNiP5ImEDTvKli3Lly5dKjsqNn4TXdEgz9buiCV0frp168YLFizIa9WqJWMOU0Gqflicbfi7xLzuh00OeDp06CA7Ovg/bMfL1A8DvzI/PWFt9tOTKcr8wFIOgkclSa/Thw4digoulCMIDx48GGlAFx5dl1eHur9x4wavVKmSlIv5SfR8/XpzNt/Qk9bnRE36ULdFixZRQYhEuXPnzrj9smHo4vu+ffvkQ2Ky1Uuz+Q0+l7aw1dfpe/bsMba7ra7XRnX//v37yEjpwIEDMmFj5AR6GB6vfJVQihYt6oSZ3ga1a9eOqoPptrt37xrlBPmLclu7A8Phw4dHyW3Tpg3fuHFjhBYWZ5s9LjGvY2iTAx5MO65evVraOHXqVL5kyRIjNt42Md376Qlrs0l+pqL5gaUHcOnSpY0Ngp5BoUKFosoKFy4sewyqvguPrssGMIbb6FWiHD0v9Hxwb/PBRp84caIcduLNPWvWLD5y5Ehep06dKB9Q1+sX7u/fvx+3XzYMXXzHdA1GNTZsdLrNb/C4tIWtvk63yTHVBU2/dFv1XrOi+/WsbTy6zPbt2/Pbt2/zmjVrOuHlxS5Xrlwx9Ux+oZ6NrmSi3NbuaFP03HX9aGN0ShQtDM5+9rjEvBcH/V7/P6YMMTIFbdu2bXzEiBExeNnqeul++IW12Ss70937gaWc9eOxBVN6JWuVQFOTrOFXhQoVeJ8+ffikSZO42PIl566nT58eCTr4bErW2IGicHHx3QVDF57PnayRwPQ4wFywFx+8pP1ixfTwmOajq1evHjhn7eVRsrt37y7nmTGlYNIXRLPZH5bu2qYSMM+ljyrC4myzE/YExbyOjUmO107vPabmgvD1lpv06DxhbPbKznT3QWDBYT8e07Aa0wdB0yBeHgUs5p8xj2wCGotqWHxCWWqmQUyyEWjo5aky+KzPT4OOuUQMSxWPi++6PJNenebne5hpECR223ZGF5sxevAuqGHkoccBRiX63Cr8AF5+sWLyH1svseCpl3l3g7jwoP6QIUP4kydP5Dy6SZcLzWZ/WLrSZauHcmDoxdlrY1ic/fR5ZXtjXi+3ycHWSLxAsPPmz3/+M79161bcWEOfX6x67cW9n80m/kxFszWKS8OBB71TbN3Bw6wvxPXq1SvSiC48Sh8WqdA7ypEjR0wQYDFRbfNSC4zLli2zJgibb5gXxQp7+fLl5YsBw1TMw4Gu7EBdLPZgwRR+YR4TvUAs9CmeMH7ZbNFx9vPdu8CIuXvb3tb9+/fLXQUmDF1sxnwkFtXKlCkjF//wgGIXiu5D69atJR7ABfgAJ+Dl4qfus9pD3aRJE547d26539q2z9qPZ/z48XKhGQtyqXlAbfaHpetxZLMHvm7ZskViCJwxMsGOH0wtqDphcbbZ6RLzup02OZiaWLt2rbQPzwyeSZt/LnS/WA1rs4u+pOaxNYpLw4EHb9ixY8fKrWR4WMSvmmL2zbrwKH2Yb8RKM4aCXtvQk7t+/bpMDjbQZSXLpeo0btyYr1mzRvYQXr58Kbed4Yc22BWieCACC0NqSyIS6aBBg6L0hvEL8mw2u/gOHvFLMblTAXP3wMFrj5KDKQAk0g8fPkgkdL0uNmOXDBI2etjo+WA0gd0RXlnABwkaWzaBIRZ8vTxBPqMcCRZb9eCX+CVj1BZKVT+IRyq2XNjC52IHeGz263SLGmNdmzxlz7fffsu3b98u12CwVRA/5PGO6IJwdrHHJeZ1jGx2w9Zhw4ZJPFWidcXWxOcXq2FtNsnPTLRsaBTxAAufkuNatGgRq1ixIhOLguzEiRPs3bt36WK4gIUlEy7pAgIJzbIIUPwnXtPLDzmhYfCXDNfgwYOZ2G/Nli9fzkRPhB07doySajI0HNmYFAgkUy5ICkDT0Eh0qZMjS6eh0y6iqGfhghLxEAKEQEYhQMk6o5AmPYQAIUAIpAIB+p51KsCjqoQAIUAIZBQClKwzCmnSQwgQAoRAKhCgZJ0K8KgqIUAIEAIZhcDHZN0vHdcYIVv/Sw/P0tN+m73x+GWz00a36SY6IUAIZDkEcqa7x/+u7eHOTEkps/qV7gFBCggBQiAeBD72rPXEE48UquOGAOHshhNxEQKEQAwC2SNTFDFFgoCecMlGjLXcxdg/Pmesxz3GGq9iLE+JaO7yHRlre4Sx3q8Y++4qY38z0CTNn2brdXvpFfuLEzrPM9bnNWOdLzFWcUCs3JR2wp6jH+3pco2xvx0ay5ORFH3KxKYXfsCfPm8++mfyy1aX6IQAIZAlEOAiKZu/nQB626NcJGzOcorvceQT395tuJSzRtqpGSniw0ZdrnFWprngEd+aLiQ+k1jffIKJVQ9+mONnw8cf7nBWTnykp+M5zoqLr6rBnhINOOt0IbpuWXGSS0/xLe2/7sZZroKcFRWfyux0Xtj36fQN0apmf+Ol22z3yrPxgQ4b4Q/8gn/ws1ybtLXTaw/dE74UA8kUAwGJslj0qRksb0nOumunZrTex1mK2wkm1oTsmqxbic+TepMukrOeBMFTJfr0DZn0mn46fSMhk3WZ6FNp5MsPvtDDRBhQDFAMiBgI3rr38Hj08OLlHTENUvwT7U9/x9gdMU2SEVfhaozdPxSt6d6B6PuiXzF27T+iaXf3MVakRkZYGL+O+x4/7h9krHDV+OVRTUKAEMhUCATvBvnw9vM5nD1XtG7+wc2Wrjdi+Vzrxtb8fJRktPnzoUWaCYFMjUBwsg5y/+EvHxchf//PIE7G3r9kLEce8a9YiPRerx98XLh8dfdTyZ9EL1m//u80Y8VqM/a/mz9Ri9eN5rkvFjp3dGFMl+PVldb3fn656ipej7Gb//OJG37CX7oIAUKAEBAIBE+DBMF08l8Yq/MXJuZYmVhgZKxgJcbqzjPXevir2L3Rn7FsOWLLb21j7B+mM5avjJCTT7wAGgo5c6L5Tv0rY7VnfUzYOfMzVqL+x3ud69d/YqzR8j94hJy/KswYdqu0EPLT6/Lzy1Un/II/8AuJGvcnhb90EQKEACEgEMgpt+fh0rfIhdkP/Pt/ieQrOuhfiaRdpDpjmNP+dbIZ3IPDGWu4RCThuaJc/FhG13NohEhQIum3P/ExWT84xtjh0WLb4M5Psm78t+h9lxQyljJWoAJjz38XukRy/nrxJ55bW8T/xXTJ3/+bSHq1xP/F++iemLM+NdVsU1pQ/fzybj204Xzin4Ufwq/8KYw9uyIStcDz5sa0sI5kEAKEQCZAAD8v/CNbZwJvyAVCgBAgBDIpAqmfBsmkwJBbhAAhQAgkEgKUrBOpNcgWQoAQIAQsCFCytgBDZEKAECAEEgkBStaJ1BpkCyFACBACFgQoWVuAITIhQAgQAomEACXrRGoNsoUQIAQIAQsC2bn44Jv6s/AkLRl+ZZVLb8fP6Xc8utu2bctOnTrFXr16xU6ePMlatWoV02xBPE2bNmXr169njx49Yk+fPmVHjhxhffv2jZETRAhrf1j+IP2u5Ta9NnoYuSqW/Oq0a9eOXbkifg8grk6dOrELFy74sWd4WWpxyHCDXRQKpxLqi1ZB9uTPn5/PnDmT37lzhz98+JAvWLCA58mTx+hDkCyBj7He56Knlb1pJSceHMLqrlGjhmxLkWxlOzZr1kzeV61aNdI2LjzQu2PHDt6wYUOeN29eXqVKFb5582Y+YcKEUG0c1v6w/PFgaqpj02ujm2T40YLkzJgxgy9cuFBiO3v2bD5v3rxQOPvpTouyIPvTQkeGy0g0p/zsyZYtG9+0aRNfvHgxL1euHC9ZsqS8nzJlSkIFSryN6Od7GJlpJSeMTsUbVvf8+fP5mDFjotpv3LhxUQ+/C8+0adM44kO3OSUlRSb+MH6EtT+M7LTkTW87g+QfP36c9+7dW2J79uxZ3rVr11A4pyUWJllB9pvqJDzNxSnwlChRgq9YsYKLYSa/d+8eHzVqVKRxRo8ezS9fvszfvHkj/9XLFABBPNBhunQAERCHDx/m2bNnj+hGD+zSpUtRgaLLMTUAfJk7d6609cWLF/zx48cy6Yvhd0QOZPTr149fvHiRv379mp87d46LYXVMQAb5pfRDng1Dk9+geW3v2LEjF8N7LqYL+NWrV/nAgQNjeFDHVFeXFWSzrb6X3r9/f37+/HmJD9pgwIABgbq9Pp05c4ZXq1Ytyg/0pE+fPh2hufB45eK+WLFi/MGDB0aMTPwKu0aNGvFdu3bx58+fy1hftWqVbDu9jt5mNllKnq3dUS6mE/jRo0dlm167do0PHTo0xl4XnIPscYl5r39evypXrqyrMf7fW8d2j8p+zxew+PLLL2OwgDzQUa5ku+BjsyOp6N4H0GQ8eDZs2MB79uzJixQpwkuVKsXnzJkjwcLbFYmsXr16HFMU9evX52L+ivfo0SMCpguP0utnz7p162RCAG/dunX5zZs3+cqVK/nbt2+NjWqThQcRvTf4kTNnTl68eHHeuXNnvnXr1ogc1EUiatCggfQL+uBny5bisAOh39V33S8bhi6+46FGgDZv3pwXKFCA48H5+WfziTw2v11tttXX6WIOWeIBXIAPcEK72+oqH73/Pnv2jOfLl0/iuXfvXr57924pT8w7R3B24fHKxf3kyZMjcWoqN9FgP5InEjbsKFu2LF+6dKnsqNj4TXRFgzxbuyOW0Pnp1q0bL1iwIK9Vq5aMOUwFqfphcbbh7xLzuh82OeDp0KGD7Ojg/7AdL1M/DExlkO/3fC1btszaW0enDeWQGxYfky1JQ/NrFOUEeFSS9Dp26NChqOBCOYLw4MGDkQZ04dF1eXWo+xs3bvBKlSpJuZifxJvZrzdn8w09aX1O1KQPdVu0iD69BYly586dcftlw9DF93379smHxGSrl2bzG3wubWGrr9P37NljbHdbXa+N6v79+/eRkdKBAwdkwsbICfQwPF75KqEULVrUCTO9DWrXjj4dCdNtd+9qpyMJHHV+r279HnjY2h0YDh8efapRmzZt+MaNn041CouzDX+XmPfabfML046rV6+WGEydOpUvWbIkFMaoh8vv+fr+++/5jz/+KOWig4gRzhdffCHvMeWFcvw/LD42n5KCbmtc3XjwlC5d2tgg6BkUKlQoqqxw4cKyx6BkuPAoXj97MNxGrxK86Hmh54N7Wx0bfeLEiXLYid7GrFmz+MiRI3mdOnWifEBdr1+4v3//ftx+2TB08R3TNQhal6Cy+Y26Lm1hq6/TbXJMdUHTL90Hvdes6H49axuPLrN9+/b89u3bvGbNmk546XVhZ65cuWLqmfxCPRtdyUS5rd3Rpui56/rRxuiUKFoYnP3scYl5Lw76vf5/TBliZAratm3b+IgRI2LwstVVdODi93yhM4VRFvjxfOJlo6aI0GFSna2w+ATZldDlQcEG4/14bGClV7JWDZyaZA2fKlSowPv06cMnTZrExZYvOXc9ffr0SNDZggk7UFSDuviuB2dQIPjh/LmTNRKYbh/mgr0PG17Sfj6Y/DfNR1evXj1wztrLo2R3795d9sIwpWDSF0Sz2R+W7tLuaFPTpY8qwuJssxP2BMW8jo1JjslWnYapuSB8dVy88YN79Xxhsfj69etymhIxgvUiTE9h1IX1GrWYHBYfV/sSkS/VP4r57bffmBg2Ct8+XaKXGrXv0oVH1X737h0TDRQlT93cunWLlS9fXt6KhmNdunRhYv7KyBtExB5RMRfJRLJmoifGvvrqKyaGVlHVxDx81D38FIEToYXxK8gelPv5/ssvvzAxj+oihr18+ZKJbXBGXhebxQPAxIJUVH3go19iATCm3cX8tVGnH1EMY5kYDkextG7dmolRT4TmwgPmIUOGsJ9++olhDzD2WSf6BRvFFAsTiSfqL0eOT4dzpBXOwMIl5v0wg52IQZFQmUia7Ntvv2ViBBOxXaxh+FWPKfN7vsRLgB07dowNGzZM/g5ETLUwsSVT7p3HswAarrTEJ8bARCOY3qDCxqg3pB8PeqfYuoNpBH0hrlevXhEZLjxKJxap0DsSARvzlsZiotrmpRYYsdBgs89Gx7woVpBF4pdvbgxTMQ8HurIDdbEAggVT+IV5TLzhsdCneML4ZbNFx9rPd+8CI+bubXtb9+/fL4eMJgxdbMZ8JBbVypQpIxf/sHcZu1B0H0RClXgAF+ADnICXi5+6z2oPdZMmTXju3LnlfmvbPms/nvHjx8uFZiw4eeM3zL3N/rB0PY5s+uHrli1bJIbAGSMT7PjB1IKqExZnm50uMa/baZOD6ZS1a9dK+/DM4Jm0+edHh/yg5wvP+pMnT/gPP/wgdWDPPNYO9K2eYfHxsynhy2yN4tJw4MFwZOzYsXJogodFvL1j9s268Ch9mG/ESjOGgl7bsEqOoRGSgw1YWclyqTqNGzfma9askdu6RC9UbjvDD22wK0TxQAQWhtSWRCTSQYMGRekN4xfk2Wx28R084pdiciiIuXvg4LVHycEUABLphw8fJBK6XhebsUsGCRvz8xiqYxEHuyO8soAPHjhs2QSGWPD18gT5jHIkWGzVg1/il4xRWyhV/SAeqdhyYQufix3gsdmv0y1qjHVt8pQ9onfKt2/fLtdgsFUQP+TRdxyBLwhnF3tcYl7HyGY3bBW9XYmn6hS4YuuVH/R84SWGq2LFilIf/sXlXQAOwice+xKxTjY4j+FNslyLFi1iotGYWHRgJ06ckFMH6XEJWOTwji5CICsikN7xn97yM2ObyTlrAIe/ZLgGDx7MxH5rtnz5ciZ6InJei5JqMrQc2ZgMCCRTLkgGPNPSRjqD0YImvfktwBCZEEgDBOj5Cg8iJevwmFENQoAQIAQyHIFUb93LcItJISFACBACWRABStZZsNHJZUKAEEg+BChZJ1+bkcWEACGQBRGIStbffPMNEx9ICoQhkXaOeG0Oa1tY/kBwHBlsem10R7HERggQApkYgcgPBvAlO5H8An9AIBJKII/AK4Yn3nomWYrmtTmsjrD8fraEKbPptdHDyCbe2NgjTAiTZI+BSM8aPVRcLj1ryZgAV1rYnGh7tBPNngRoZjKBECAE/kBA9oC9PVTQ8OdyCgO+W4FvD+DnwvjimfiVYdTnPNFbNF1Kh/o3SI6X32Qz9NBJH9SL8sYK3VNMZIIYYHLqA4nP64zrKQw4YQUf2cFBpfgOA76zgaOQvPKChviuciDXZjN00Ekf9GB6Y4/uKSYyQQzYe9XxnsKAI4rwsXAvOEHJ2stvkwM+U68adFzeD71kxZM+vFjSPSUrioEkjwFbDxUNa/u4vp50cbIFTlvBV9fwBTt14Ytv3uDwS9Zh5PjZDB100keSB6VhcdobS3RPbZzlYsDWQwUQLqcw4JQVzFFXqVKFiw/eywRtO2rLL1mHkeNns01HWLoKBFs9lCfySR9ZLpApwcd0jigGMtkLzTRXrRoZZxTqJy2Djm/t6gkMHwfHR9P1wMA3qU1JDt+7xsf+TUHkKsevVw25Jr3x0JWNNnkoBz7iRBWjP2Ew1PHw0+fFDcco4QxDL53uM9lDSi8iinHEAJKf7eF2OYUBh1dOnjxZJmz8fffdd3JKxJR0/E5CcZXj16uGHya98dAVJjZ5KE/kkz5sbUp0SuQUA0kbA/6GB53CkJKSIo/5wUGX6lSRr7/+2pg0/U6BcZET1Kt2TcrSOMvlDWS/ZA3eRD3pw+sH3fvHOeFD+CRBDCRPIwX1qpMAbOsohmxPnjiktqK2+hwxQN+zFqjTRQgQAoRAoiNAX91L9BYi+wgBQoAQEAhQsqYwIAQIAUIgCRDImQQ2komEACGQiRAQi/aB3tAHzWIh+n+La+iFQOBJEAAAAABJRU5ErkJggg==)
make
make PREFIX=/data/hiredis install (指定安装路径)
修改redis_fdw的Makefile(/usr/postgresql-9.4.1/contrib/redis_fdw/Makefile)
vi Makefile
# 末尾追加
LDFLAGS += -L/data/hiredis/lib (此为上面指定的安装路径)
安装redis_fdw
按照德哥的文档来,但是我一直遇到了libhiredis.so.0.11无法与redis_fdw.so无法共享或者文件不存在的问题,一开始走进了权限的谜圈,一直在纠结文件权限的问题,chown,chmod都整过了,依然没有进展,于是尝试着把libhiredis.so.0.11拷贝到redis_fdw.so目录下,奇迹般的解决了,得来全不费工夫。
以上就是安装的过程了。后面配置的过程可以参考德哥的文章,写的很好。非常感谢德哥的分享。
参考文档:
奋斗