Re: Massive delete from a live production DB

Dne 12.5.2011 17:37, Phoenix Kiula napsal(a):
> [mydomain] src > cd pg_reorg-1.1.5
>
> [mydomain] pg_reorg-1.1.5 > gmake
> Makefile:13: ../../src/Makefile.global: No such file or directory
> gmake: *** No rule to make target `../../src/Makefile.global'.  Stop.
>
> [mydomain] pg_reorg-1.1.5 >
>
>
> What am I missing?

Do you have a source or just a binary package? To compile such contrib
package you need a properly configured source tree.

If you do have the sources already available, you need to run configure
(because that's what produces the src/Makefile.global). And then build
the contrib module again.

If you don't have the sources, you can download the distribution at
postgresql.org. But maybe there's a src package for your distro.

> PS. If pg_reorg is such a useful contribution, why can't it be
> included with PG? Seems like a very useful tool anyway! No?

There's a lot of packages that might be included into the default
install, but that'd put a lot of responsibilities to maintain them.

regards
Tomas