Re: Massive delete from a live production DB

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Eric Ndengang <eric(dot)ndengang_foyet(at)affinitas(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Massive delete from a live production DB
Date: 2011-05-12 15:37:11
Message-ID: BANLkTikYiQOwm+1d4aL1u6XrGhVsKrpQGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[snip]

> You can easily install it as a contrib . Just read the installation guide or
> the man Page.

Thanks Eric. How though?

The instructions here --
http://reorg.projects.postgresql.org/pg_reorg.html -- are woefully
incomplete.

I have a standard PG install on WHM/Cpanel type server. I know the
path to pgsql. I can download the pg_reorg.1.1.5.tar.gz into this
folder and untar it. Then what? A "make" and "make install" does not
work -- the usual "./config" stuff is not available.

Sorry, I need more detailed steps.

I googled and found this:
http://www.postgresql.org/docs/9.0/static/contrib.html

But the recommended steps:

gmake
gmake install

...don't work either. Here's what I see:

[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?

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?

Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-05-12 16:04:56 Re: Massive delete from a live production DB
Previous Message Marti Raudsepp 2011-05-12 15:31:29 Re: Massive delete from a live production DB