May 2018
Intermediate to advanced
576 pages
30h 25m
English
Try to make a minimal repeatable test scenario that exhibits this bug. Sometimes, the bug disappears while doing this, but mostly it is needed to make the process easy. It is almost impossible to fix a bug that you can't observe and repeat at will.
If it is about query processing, then you can usually provide a minimal dump file (the result of running pg_dump) of your database together with a SQL script that exhibits the error.
If you have corrupt data, then you may want to make a subset of the corrupted data files available for people who have the knowledge and time to look at it. Sometimes, you can find such people on the PostgreSQL hackers' list, and sometimes you have to hire someone or even fix it yourself. The more preparatory ...