How to load a backup DB file in AWS RDS Postgresql

Question!

I've got a PostgreSQL backup file (tar zipped) and I would like to restore it in fresh Amazon RDS instance. I loaded the backup file in S3 but I don't know how to restore it in Postgresql RDS. Thanks for your help.



Answers


the timezone error was coming up as a result of the character set i selected for my database. it was suppose to be utf8 however, i choose some other one. i had to uninstall my database, and recreated a new one using "utf8" character set, which happens to be a general standard. :)

By : David


var text = "|+HP:+20";
// Break string into an array of strings and grab last element
var results = text.split('+').pop();

References:

By : Ouroborus


This video can help you solving your question :)
By: admin