Clarify Requirements for Postgresql Job Manager

[C-Loftus]

Currently in the docs for the Postgresql OGC API Process Job Manager, it says that jobs will be stored in a table called jobs.

However, it does not clarify if this table is automatically created or if the user has to create it themselves. In a database without this table I get the following error:

sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) not available in Engine(postgresql+psycopg2://postgres:***@127.0.0.1:5432/edr) schema 'public': (jobs)

This leads me to believe that the table must be created but I am unclear what sort of columns I would need in this table

I am using

pygeoapi, version 0.22.dev0

on MacOS

I am happy to make a PR to the docs with this info, I just wasn't clear what the intended behavior is.

[francescoingv]

@C-Loftus
At the top of process/manager/postgresql.py file there are the instruction to make what is required:

# Import dump:
# psql -U postgres -h 127.0.0.1 -p 5432 test <
#   tests/data/postgres_manager_full_structure.backup.sql

If you need additional information to update the docs, please let me know.

[tomkralidis]

PR in #2156.

[C-Loftus]

Thank you both! That is very helpful 👍