Minor change: rolled the tiles version in to the code since we're not going to change it much anyway
Code to download the sql backup and install it
Bumped webtree version number to put the tree in the right place
Added authentication details to the psql command
moved the PGPASSWORD into exec's environment field
added missing comma
Got the psql command working and made sure the command is used if the database has not been restored already
Added an always_refresh option which will force the download to go ahead

1) I did this with a hack which deletes the downloaded file from disk - probably a better fix would be to check the wget module
2) I changed the unzip command to unzip and replace files but to only run if the zip file is newer than the target
Set the tiles to always refresh each time puppet is run