`ExecutableMissingException`

[trymzet]

Hi, I followed the installation and getting started instructions, but I'm getting below error:

pytest_postgresql.exceptions.ExecutableMissingException: Could not found /usr/lib/postgresql/17/bin/pg_ctl. Is PostgreSQL server installed? Alternatively pg_config installed might be from different version that postgresql-server.

Here are the exact steps I executed:

pip install pytest-postgresql
pip install "psycopg[binary]"

After testing the code (postgresql_proc = factories.postgresql_proc()) and getting Permission denied: 'pg_config', I found in some issue that I should install libpq-dev as well, so the next step was:

sudo apt install libpq-dev

However, now I'm getting the error described in the issue, so I'm probably missing some more installation/configuration steps?

I saw someone getting a similar error, but they were running a Docker container with PostgreSQL and connecting to that, whereas I wanted to let the lib create and manage the instance.

[fizyk]

@trymzet do you have a Postgresql server installed, or do you plan to use dockerised postresql?