Re: Is dropping pg_ts_* harmful? - Mailing list pgsql-general

From David Fetter
Subject Re: Is dropping pg_ts_* harmful?
Date
Msg-id 20090202220826.GM17601@fetter.org
Whole thread Raw
In response to Is dropping pg_ts_* harmful?  ("Eric Brown" <ebrown@mediweightloss.com>)
List pgsql-general
On Mon, Feb 02, 2009 at 09:40:16AM -0500, Eric Brown wrote:
> I have a database running very happily in 8.2 (to be upgraded soon).
> The system was installed with tsearch2 enabled, however, we have yet
> to use it. I am going through an effort to reduce "cruft" in the
> database, which includes four tables: pg_ts_cfg, pg_ts_cfgmap,
> pg_ts_dict, pg_ts_parser. Are these tables safe to drop? Will the
> remnants of tsearch2 be anywhere else in the database if it was
> never used?
>

There should be an uninstall_tsearch2.sql script somewhere on your
system if you have a relatively recent 8.2.  That should scrub
everything :)

Cheers,
David.
> Thanks folks --
>
> -- Eric Brown / Director of IT / www.mediweightlossclinics.com

--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: plpgsql and control structures
Next
From: wstrzalka
Date:
Subject: Re: Pet Peeves?