Search Postgresql Archives

Re: Is dropping pg_ts_* harmful?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@xxxxxxxxx

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux