<p>This article describes how to restore backup.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <p>There is backup data in the instances. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Backup_and_Restore.Automated_Backup" target="_blank">Automatic Backup</a> and <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Backup_and_Restore.Manual_Backup" target="_blank">Manual Backup</a>.</p> <p><span style="font-size:18px"><strong>Usage Guidelines</strong></span></p> <p>1.&nbsp; The restored data is stored in a temporary recovery instance newly created by RDS PostgreSQL service of Ping An Cloud:</p> <p>&nbsp; &nbsp; &bull;&nbsp; The region of the newly created temporary recovery instance is the same as that of a general instance. The temporary recovery instance will not be charged additionally.</p> <p>&nbsp; &nbsp; &bull;&nbsp; The newly created instance can be stored for a maximum of seven days and will be released after seven days.</p> <p>2.&nbsp; The newly created temporary recovery instance adopts the minimum specifications. The storage specifications are the same as those of the general instance on which the restoring operation is performed.</p> <p>3.&nbsp; After the temporary recovery instance is successfully created, the computing and storage specification will not change.</p> <p>4.&nbsp; Each general instance can create a maximum of three temporary recovery instances. If you need to create the fourth one, release the previously created temporary recovery instances first.</p> <p>5.&nbsp; The temporary recovery instance will automatically create an account. Its username is temp_root and it has the read/write permission of the instance.</p> <p><span style="font-size:18px"><strong>Procedures</strong></span></p> <p>1.&nbsp; Log in to the <a href="http://pinganyun.com/console/rds/overview" target="_blank">RDS Console</a>.</p> <p>2.&nbsp; In the left navigation pane, click <strong>RDS-PostgreSQL</strong> to enter the <strong>DBPaaS for RDS-PostgreSQL</strong> page.</p> <p>3.&nbsp; Select the target region.</p> <p>4.&nbsp; In the <strong>Operation</strong> column of the target instance, click <strong>Manage</strong>. Click <strong>Backup</strong> tab.</p> <p>5.&nbsp; In the <strong>Information</strong> area, click <strong>Restore</strong> in the <strong>Operation</strong> column of the target backup to enter the <strong>Restore backup</strong> page.</p> <p>6.&nbsp; Restore backup based on the following information.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:137px"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:651px"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:137px"> <p>Restore method</p> </td> <td style="vertical-align:top; width:651px"> <p>The restore method of backup data includes restoring <strong>by backup set</strong> and <strong>by time</strong>:</p> <p>&bull;&nbsp;&nbsp;<strong>By backup set</strong>: It can restore the database information of the backup time.</p> <p>&bull;&nbsp;&nbsp;<strong>By time</strong>: It can restore the database information of any time from the first backup time to two hours earlier than current time.</p> <p>For example: You created a general instance at 00:00 of May 1, 2019. The current time is 12:00 of May 5, 2019. During this period, two manual backups were performed at 14:00 of May 2, 2019 and 20:00 of May 3, 2019 respectively. If you restore data with the following two methods:</p> <p>&bull;&nbsp; Restore <strong>by backup set</strong>: You can restore database by backup time. For example, you can restore database information of 14:00 of May 2, 2019 or 20:00 of May 3, 2019.</p> <p>&bull;&nbsp; &nbsp;Restore <strong>by time</strong>: You can restore database information of any time from 14:00 of May 2, 2019 to 10:00 of May 5, 2019.&nbsp;</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174523-110686289fe5.png" style="height:225px; width:650px" /></p> <p><!--[if gte mso 9]><xml> <o:OLEObject Type="Embed" ProgID="PBrush" ShapeID="_x0000_i1025" DrawAspect="Content" ObjectID="_1655562293"> </o:OLEObject> </xml><![endif]--></p> </td> </tr> <tr> <td style="vertical-align:top; width:137px"> <p>Restore Time</p> </td> <td style="vertical-align:top; width:651px"> <p>If the restore method is by time, you need to configure it to set the time for restoring backup.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607173923-163d089f9cd2.png" style="height:23px; margin:0px; width:90px" />: It should be set as any time that is two hours earlier than the current time.</p> </td> </tr> <tr> <td style="vertical-align:top; width:137px"> <p>Set a temporary user password</p> </td> <td style="vertical-align:top; width:651px"> <p>It refers to login password of temporary recovery instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607173923-163d089f9cd2.png" style="height:23px; margin:0px; width:90px" />: RDS PostgreSQL service of Ping An Cloud will restore and store data in the newly created temporary recovery instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607173930-1f895eb39f00.png" style="height:29px; margin:0px; width:65px" />:</p> <p>1.&nbsp; The length of password is 8 to 32 characters.</p> <p>2.&nbsp; It must contain uppercase and lowercase letters, digits, or special characters such as exclamation points (!), at signs (@), dollar signs ($), asterisks (*), parentheses (), underscores (_), and equal signs (=).</p> </td> </tr> </tbody> </table> <p>7.&nbsp; Click <strong>Save</strong> to enter the<strong> Restoring</strong> page</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174010-15089c589434.png" style="height:211px; width:512px" /></p> <p>8.&nbsp; Click <strong>Got it</strong>. On the <strong>DBPaaS for RDS-PostgreSQL</strong> page, you can view that <strong>Status</strong> of the temporary recovery instance is <strong>Backup Creating</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174027-1c783d569b36.png" style="height:97px; width:830px" /></p> <p><span style="font-size:18px"><strong>Result</strong></span></p> <p>On the <strong>DBPaaS for RDS-PostgreSQL</strong> page, you can view that <strong>Status</strong> of the temporary recovery instance is <strong>Running</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174033-1fc22ded9717.png" style="height:167px; width:830px" /></p> <p><span style="font-size:18px"><strong>Subsequent Procedures</strong></span></p> <p><span style="font-size:14px"><strong>&bull;&nbsp; &nbsp;View Basic Information of a Temporary Recovery Instance</strong></span></p> <p>In the <strong>Operation</strong> column of the target temporary recovery instance, click <strong>Manage</strong>. Click <strong>Information</strong> tab and you can view <strong>Instance Name, Domain Name, Port, Recovery Source,</strong> and <strong>Recovery Effective Time</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174040-10b285c092b5.png" style="height:187px; width:830px" /></p> <p><span style="font-size:14px"><strong>&bull;&nbsp; &nbsp;Create a Whitelist</strong></span></p> <p>The region of a temporary recovery instance is identical with that of a general instance. You can see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Security_Management.Create_Whitelist" target="_blank">Create a Whitelist</a> of a general instance for creating a whitelist of the temporary recovery instance. For more information about deleting the whitelist of the temporary recovery instance, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Security_Management.Delete_Whitelist" target="_blank">Delete a Whitelist</a> of a general instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174155-1295af1a9d20.png" style="height:149px; width:1068px" /></p> <p><span style="font-size:14px"><strong>&bull;&nbsp; &nbsp;Modify Password of an Account</strong></span></p> <p>In the process of restoring backup, RDS service of Ping An Cloud will create an account with the username of temp_root. In the <strong>Operation</strong> column of the target temporary recovery instance, you can click <strong>Manage.</strong> Click <strong>Account</strong> tab. Select the target account and click <strong>Modify Password</strong> in the upper-right corner to modify the password.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607173930-1f895eb39f00.png" style="height:29px; margin:0px; width:65px" />:</p> <p>1.&nbsp; The length of password is 8 to 32 characters.</p> <p>2.&nbsp; It must contain uppercase and lowercase letters, digits, or special characters such as exclamation points (!), at signs (@), dollar signs ($), asterisks (*), parentheses (), underscores (_), and equal signs (=).<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174203-1adc3d2a9f04.png" style="height:120px; width:830px" /></p> <p><span style="font-size:14px"><strong>&bull;&nbsp; &nbsp;Release a Temporary Recovery Instance</strong></span></p> <p>Before the temporary recovery instance expires, in the operation column of the target temporary recovery instance, click <strong>Release</strong> to manually release the instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_PostgreSQL.Instance_Management.Release.Release_Common_Instance" target="_blank">Release an Instance</a>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607174212-1384b4599b67.png" style="height:100px; width:830px" /></p>