fixed database creation for postgres

fixed tests for psql:

- [x] test coverage
- [x] finish the code
- [ ] gather feedback for my changes
- [x] submit changes to the documentation


| Q             | A
| ------------- | ---
| Bug fix?      | yes
| New feature?  | none
| Tests pass?   | none
| Fixed tickets | yess (all)
| Doc           | none