<p>This article describes how to install a PostgreSQL client on the ECS in Windows operating system and access an RDS PostgreSQL instance via PostgreSQL client.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <ol> <li>You have successfully created an RDS PostgreSQL instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_PostgreSQL.Create_RDS_PostgreSQL" target="_blank">Create an RDSPostgreSQL Instance</a>.</li> <li>You have successfully created an ECS and the instance is in the status of running. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_PostgreSQL.Create_ECS" target="_blank">Create an ECS</a>. Select a windows image when you create the ECS.</li> <li>You have successfully opened a whitelist. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_PostgreSQL.Create_Whitelist" target="_blank">Open a Whitelist</a>.</li> </ol> <p><span style="font-size:18px"><strong>Procedures</strong></span></p> <p>1.&nbsp;Log in to a Windows&nbsp;ECS instance. For more information, see&nbsp;<a href="http://pinganyun.com/ssr/help/compute/ecs/Quick_Start.Windows_Quick_Start.Login_Instance" target="_blank">Log In to Instance</a>.&nbsp;</p> <p>2.&nbsp; Download and install pgAdmin client. For more information, see <a href="http://www.pgadmin.org/download/" target="_blank">pgAdmin Official Website</a>. This section takes an example of Windows operating system and pg Admin 4 client. For more information, see <a href="http://www.postgresql.org/ftp/pgadmin/pgadmin4/v4.5/windows/" target="_blank">Download Site</a>.</p> <p>3.&nbsp; Start pg Admin client.</p> <p>4.&nbsp; In the left area of <strong>Browser</strong> of the page, right-click <strong>Servers &gt; Create &gt; Server</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20191507142635-101a6b2096a3.png" style="height:118px; width:446px" /></p> <p>5.&nbsp; On the <strong>Create - Server</strong> page, configure parameters on the <strong>General</strong> tab as described in the following table.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Name</p> </td> <td style="vertical-align:top"> <p>Name of the server group.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Server group</p> </td> <td style="vertical-align:top"> <p>Type of the server group.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Connect now?</p> </td> <td style="vertical-align:top"> <p>Whether to connect now.</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>Comments</p> </td> <td style="vertical-align:top"> <p>Notes.</p> </td> </tr> </tbody> </table> <p>6.&nbsp; Configure parameters on the <strong>Connection</strong> tab as described in the following table.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:166px"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:622px"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Host name/address</p> </td> <td style="vertical-align:top; width:622px"> <p>Domain name of the target RDS PostgreSQL instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207150036-187a460d960b.png" style="height:22px; margin:0px; width:90px" />:&nbsp; It can be viewed on <strong>Basic Information</strong> page of the target RDS PostgreSQL instance. For more information, see View Basic Information of an Instance.</p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Port</p> </td> <td style="vertical-align:top; width:622px"> <p>Port of the target RDS PostgreSQL instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207150036-187a460d960b.png" style="height:22px; margin:0px; width:90px" />:&nbsp; It can be viewed on <strong>Basic Information</strong> page of the target RDS PostgreSQL instance. For more information, see View Basic Information of an Instance.</p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Maintenance database</p> </td> <td style="vertical-align:top; width:622px"> <p>It is the name of database that needs to be connected and it is postgres database by default.</p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Username</p> </td> <td style="vertical-align:top; width:622px"> <p>The created name of administrator.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207150036-187a460d960b.png" style="height:22px; margin:0px; width:90px" />:&nbsp; It can be viewed on <strong>Account</strong> tab of the target RDS PostgreSQL instance. For more information, see Create a General Instance.</p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Password</p> </td> <td style="vertical-align:top; width:622px"> <p>Password of the administrator.</p> </td> </tr> <tr> <td style="vertical-align:top; width:166px"> <p>Save password?</p> </td> <td style="vertical-align:top; width:622px"> <p>Whether to save the password.</p> </td> </tr> </tbody> </table> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20191507142815-1d7efd4894e3.png" style="height:541px; width:486px" /></p> <p>7.&nbsp; Click <strong>Save</strong>.</p> <p><span style="font-size:18px"><strong>Result</strong></span></p> <p>The RDS PostgreSQL Database is successfully connected.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20191507142839-17f1057e9bec.png" style="height:353px; width:830px" /></p>