Cannot pass existing temporary directory to TemporaryPostgres

[lilyminium]

Thanks for having a look at the other bugs I raised, @bennybp! I put off raising this one because I haven't put together a MRE, but I think if you inspect the code then the issue becomes clear.

Describe the bug

I cannot pass a tmpdir into TemporaryPostgres because:

1. TemporaryPostgres assumes tmpdir has a name attribute
2. TemporaryPostgres assumes the name attribute is the absolute path / TemporaryPostgres does not account for directories that are not within the current working directory.

To Reproduce

Both behaviours are down to this line:

QCFractal/qcfractal/postgres_harness.py

Line 483 in 00d9899

config_data = {"port": find_port(), "directory": self._db_tmpdir.name}

.name for a pathlib.Path only gives the last portion of the path, i.e.

>>> import pathlib
>>> path = pathlib.Path("/Users/lily/anaconda")
>>> path.name
'anaconda'

And of course strings do not have .names (the documented type is Optional[str]).

Expected behavior

I can give either a string or a path.

Additional context