fix many broken tests, some cleanup

- add single method to obtain PgConnection and add 5432 as
  fallback port
- disable delete confirmation dialog
- disable nose stdout capturing (rendered console useless)
- fix typos, other basic bugs