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.
How to load a backup DB file in AWS RDS Postgresql
Amazon has a very good document for this procedure.
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. :)