pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Tsearch module - please help.
2+ messages / 2 participants
[nested] [flat]
* Re: Tsearch module - please help.
@ 2009-02-12 15:08 Carol Walter <walterc@indiana.edu>
2009-02-12 16:25 ` Re: Tsearch module - please help. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Carol Walter @ 2009-02-12 15:08 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
The database is within my 8.2.4 instance. I've also got an 8.3.4
instance running. I'm trying to move the database to the 8.3
version. I can't back up the database. When I try to back it up
using pg_dump or pg_dumpall, I get a "failed sanity check error". I
can copy the data out of the tables using the sql copy statement. My
solution is to manually recreate the table schema, then copy the data
into the tables. All worked well except for two tables. These tables
are called pg_ts_dict and pg_ts_parser. I cannot copy the data from
these tables into my new database because the functions that are in
their columns do not exist in the database. There are two other
tables with names that also suggest that they are related to full text
searching. They are pg_ts_cfg and pg_ts_cfgmap. This is the only
database in the cluster that uses or tries to use full text searching.
This is a database developed by graduate students for a faculty
research project. My problem is that I know nothing about how this
process works. I know from my reading the tables that I see in the
database are tables that are included with the tsearch2. I don't know
if it's a normal situation for those tables to appear in a database
just like the rest of the user tables and to be shown as being owned
by the owner of the rest of the tables. If this is a normal
situation, how do I get the functions into the database. There are a
whole host of functions in this database that list $libdir/tsearch2 as
their path. In the 8.3.4 instance which includes the full text
searching as part of the core, will these tables still appear in the
user's database.
Please help. If the answer is too long to go into, then, please point
me at documentation that tells me enough of what is going on "under
the hood" for me to figure out how to proceed.
Thank you so much,
Carol
On Feb 11, 2009, at 4:47 PM, Tom Lane wrote:
> Carol Walter <walterc@indiana.edu> writes:
>> How do I install the tsearch module in 8.4? I have found
>> documentation on it's use, but it all seems to start with "After you
>> install the tsearch module..." It doesn't say how that is done.
>
> Any documentation that says that is presumably written for 8.2 or
> before. Ignore it and see the 8.3 manual:
> http://www.postgresql.org/docs/8.3/static/textsearch.html
>
> If your problem is really about upgrading an 8.2 or older tsearch
> installation to 8.3, see in particular
> http://www.postgresql.org/docs/8.3/static/textsearch-migration.html
>
> regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Tsearch module - please help.
2009-02-12 15:08 Re: Tsearch module - please help. Carol Walter <walterc@indiana.edu>
@ 2009-02-12 16:25 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2009-02-12 16:25 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> ... All worked well except for two tables. These tables
> are called pg_ts_dict and pg_ts_parser. I cannot copy the data from
> these tables into my new database because the functions that are in
> their columns do not exist in the database. There are two other
> tables with names that also suggest that they are related to full text
> searching. They are pg_ts_cfg and pg_ts_cfgmap. This is the only
> database in the cluster that uses or tries to use full text searching.
See the discussion of 8.2 to 8.3 tsearch porting in the 8.3 docs I
pointed you to before; particularly the revised contrib/tsearch2 module.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-02-12 16:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-12 15:08 Re: Tsearch module - please help. Carol Walter <walterc@indiana.edu>
2009-02-12 16:25 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox