Re: Need full search text on a shared hosting web site using 8.1.x

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Raymond Rodgers <sinful622(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Need full search text on a shared hosting web site using 8.1.x
Date: 2009-11-16 19:52:00
Message-ID: 24852.1258401120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John R Pierce <pierce(at)hogranch(dot)com> writes:
> can't you install the contrib module as a regular database user into the
> database you own?

No, it would take superuser privs which he hasn't got. More, even with
superuser privs it would need the tsearch2.so library to be present on
disk, which it likely isn't if they aren't supporting contrib. And
(which is actually a somewhat legitimate reason for them to deny
support) it's fairly difficult to do anything useful with tsearch2
without the ability to write/edit its config files, which requires
outside-the-database filesystem access.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reno Bladergroen 2009-11-16 20:01:49 Re: createdb errors and more
Previous Message Thom Brown 2009-11-16 19:46:29 Re: [HACKERS] Update on Insert