O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Investigating and reporting a bug

When you find out that PostgreSQL is not doing what it should, then it's time to investigate.

Getting ready

It is a good idea to make a full copy of your PostgreSQL installation before you start investigating. This will help you restart several times and be sure that you are in fact investigating the results of the bug and not chasing your own tail by looking at changes introduced by your last investigation and debugging attempt.

How to do it...

Try to make a minimal repeatable test scenario which exhibits this bug. Sometimes the bug disappears while doing it, but mostly it is needed for making it easier for the one who tries to fix it. It is almost impossible to fix a bug that you can't observe and repeat at will. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required