virtualpg: update to version 1.0.1

- Upgrade to version 1.0.1
- Take advantage of compile options for non-canonical postgresql
  installs
- Fix link file extension to use dylib
- Add test of loading extension for sqlite3
- Closes #32042