I would recommend doing a fresh install on your hosted server so that the hosted variables are set up correctly. I would recommend keeping the wa_settings table without overwriting with the one from your testing server, or at least note the pg_root, pg_rooturl and Root URL from the wa_settings table on the hosted server.
Then you would want to make a backup of the database and import it to your hosted database. Then copy over those 3 rows into the wa_settings table.
You will also have to upload the imagesupload directory that should be in the root of your PowerStore.