<p class="shortdesc">本文主要介绍如何在Windows操作系统的ECS上安装PostgreSQL客户端，并通过PostgreSQL客户端访问RASESQL实例。</p> <section class="section prereq" id="Windows_RASESQL__prereq_dlw_zxm_hsb"><div class="tasklabel"><h2 class="doc-tairway">前提条件</h2></div> <ol class="ol" id="Windows_RASESQL__d51e20"> <li class="li">您已成功创建RASESQL实例，可参考<a class="xref" href="/ssr/help/database/RASESQL/User_Guide_for_RDS_PostgreSQL.Instance_Management.Create_Instance.Create_Common_Instance_MySQL" target="_blank" rel="external noopener">创建RASESQL实例</a>。</li> <li class="li">您已成功创建ECS，可参考<a class="xref" href="/ssr/help/database/RASESQL/Getting_Started.createECSRASESQL" target="_blank" rel="external noopener">创建ECS</a>，且实例处于运行中。</li> <li class="li">您已成功开通白名单，可参考<a class="xref" href="/ssr/help/database/RASESQL/User_Guide_for_RDS_PostgreSQL.Security_Management_RASESQL.Create_Whitelist_RDS_RASESQL" target="_blank" rel="external noopener">开通白名单</a>。</li> </ol> </section> <section><div class="tasklabel"><h2 class="doc-tairway">操作步骤</h2></div><ol class="ol steps"><li class="li step stepexpand"> <span class="ph cmd"><a class="xref" href="/ssr/help/compute/ecs/manual.Instance.Login_Windows_Instance.Console_Remote_Login" target="_blank" rel="external noopener">登录Windows云主机</a>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">下载并安装pgAdmin客户端，可参考<a class="xref" href="https://www.pgadmin.org/download/" target="_blank" rel="external noopener">pgAdmin官网</a>，文本以Windows操作系统，pg Admin 4客户端为例，<a class="xref" href="https://www.postgresql.org/ftp/pgadmin/pgadmin4/v4.5/windows/" target="_blank" rel="external noopener">下载地址</a>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">启动pg Admin客户端。</span> </li><li class="li step stepexpand"> <span class="ph cmd">在页面左侧<span class="ph uicontrol">Browser</span>区域，右键单击<span class="ph menucascade"><span class="ph uicontrol">Servers </span><abbr> > </abbr><span class="ph uicontrol">Create</span><abbr> > </abbr><span class="ph uicontrol">Server</span></span>。</span> <div class="itemgroup info"> <div class="p"> <img class="image" id="Windows_RASESQL__image_zhq_vym_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20231101095159-1da30e749874.png"> </div> </div> </li><li class="li step stepexpand"> <span class="ph cmd">在<span class="ph uicontrol">Create-Server</span>页面，根据以下主要信息填写<span class="ph uicontrol">Genneral</span>页签。</span> <div class="itemgroup info"> <table class="table" id="Windows_RASESQL__table_yqq_gym_hsb"><caption></caption><colgroup><col><col></colgroup><thead class="thead"> <tr class="row"> <th class="entry colsep-1 rowsep-1" id="Windows_RASESQL__table_yqq_gym_hsb__entry__1"> <p class="p">配置项</p> </th> <th class="entry colsep-1 rowsep-1" id="Windows_RASESQL__table_yqq_gym_hsb__entry__2"> <p class="p">说明</p> </th> </tr> </thead><tbody class="tbody"> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__1 "> <p class="p"> Name </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__2 "> <p class="p"> 服务器组的名称。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__1 "> <p class="p"> Server group </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__2 "> <p class="p"> 服务器组的类型。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__1 "> <p class="p"> Connect now? </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__2 "> <p class="p"> 是否现在连接。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__1 "> <p class="p"> Comments </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_yqq_gym_hsb__entry__2 "> <p class="p"> 注释。 </p> </td> </tr> </tbody></table> </div> </li><li class="li step stepexpand"> <span class="ph cmd">根据以下主要信息，填写<span class="ph uicontrol">Connection</span>页签。</span> <div class="itemgroup info"> <table class="table" id="Windows_RASESQL__table_rkr_3ym_hsb"><caption></caption><colgroup><col><col></colgroup><thead class="thead"> <tr class="row"> <th class="entry colsep-1 rowsep-1" id="Windows_RASESQL__table_rkr_3ym_hsb__entry__1"> <p class="p">配置项</p> </th> <th class="entry colsep-1 rowsep-1" id="Windows_RASESQL__table_rkr_3ym_hsb__entry__2"> <p class="p">说明</p> </th> </tr> </thead><tbody class="tbody"> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Host name/address </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p">目标RASESQL实例的访问域名。</p> <div class="note important note_important" id="Windows_RASESQL__note_b15_vv1_3sb"><span class="note__title">重要：</span> 可在目标RASESQL实例的<span class="ph uicontrol">基本信息</span>页面查询，可参考<a class="xref" href="/ssr/help/database/RASESQL/User_Guide_for_RDS_PostgreSQL.Instance_Management.View_Instance_RASESQL.View_Common_Instance_RASESQL" target="_blank" rel="external noopener">查看实例基本信息</a>。</div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Port </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p">目标RASESQL实例的端口号。</p> <div class="note important note_important" id="Windows_RASESQL__note_ivg_yv1_3sb"><span class="note__title">重要：</span> 可在目标RASESQL实例的<span class="ph uicontrol">基本信息</span>页面查询，可参考<a class="xref" href="/ssr/help/database/RASESQL/User_Guide_for_RDS_PostgreSQL.Instance_Management.View_Instance_RASESQL.View_Common_Instance_RASESQL" target="_blank" rel="external noopener">查看实例基本信息</a>。</div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Maintenance database </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p"> 维护数据库。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Username </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p">创建的管理员名称。</p> <div class="note important note_important" id="Windows_RASESQL__note_bg2_zv1_3sb"><span class="note__title">重要：</span> 可在目标RASESQL实例的<span class="ph uicontrol">账号管理</span>页面查询，可参考<a class="xref" href="/ssr/help/database/RASESQL/User_Guide_for_RDS_PostgreSQL.Instance_Management.Create_Instance.Create_Common_Instance_MySQL" target="_blank" rel="external noopener">创建RASESQL实例</a>。</div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Password </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p"> 管理员对应的密码。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__1 "> <p class="p"> Save password? </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows_RASESQL__table_rkr_3ym_hsb__entry__2 "> <p class="p"> 是否保存密码。 </p> </td> </tr> </tbody></table> <p class="p"><img class="image" id="Windows_RASESQL__image_psc_yym_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20231101095159-145460ec969f.png"></p> </div> </li><li class="li step stepexpand"> <span class="ph cmd">单击<span class="ph uicontrol">Save</span>。</span> </li></ol></section> <section class="section result"><div class="tasklabel"><h2 class="doc-tairway">执行结果</h2></div> <p class="p">成功连接RDSPostgreSQL数据库。</p> <p class="p"><img class="image" id="Windows_RASESQL__image_whv_yym_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20231101095159-154be07593ad.png" width="800"></p> </section>