stream {
    upstream pgsql_socket {
        server 192.168.214.133:32222;#pg库实际的的ip和端口
    }
    server {
        listen 9856;
        allow 192.168.214.134;#配置允许访问的IP
        deny all;#配置不可访问ip
        proxy_connect_timeout 60s;
        proxy_socket_keepalive on;
        proxy_pass pgsql_socket;#192.168.214.133:32222;
    }
}

[参考]
nginx反向代理服务器实现postgreSQL

留待后查，同时方便他人
联系我:ivesbao@163.com