test: improve lifecycle test coverage

[codecov[bot]]

Codecov Report

Attention: 2 lines in your changes are missing coverage. Please review.

Comparison is base (7c4bd40) 98.12% compared to head (feeeeb6) 98.32%. Report is 1 commits behind head on main.

Files	Patch %	Lines
postgresql_embedded/src/postgresql.rs	84.61%	2 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #16 +/- ## ========================================== + Coverage 98.12% 98.32% +0.19% ========================================== Files 53 53 Lines 6500 6493 -7 ========================================== + Hits 6378 6384 +6 + Misses 122 109 -13 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.