Fixed dependency issues for CI on Travis

* `String::Random` not required
* SKIP stock tests if `Pg` backend not provided
* Fixed `role/append*.t` for updated `File::Temp` API
* Added `libexpat1-dev` to before-install on travis-ci yaml