pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
4+ messages / 2 participants
[nested] [flat]
* postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
@ 2018-03-28 04:53 Wells Oliver <wells.oliver@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Wells Oliver @ 2018-03-28 04:53 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I get that this library is no longer need. It's blowing up my upgrade to
10. Output:
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt
Then, in the text file:
could not load library "$libdir/tsearch2": ERROR: could not access file
"$libdir/tsearch2": No such file or directory
But I can't see how or where this library is still installed. Running \dx
on my database:
Name | Version | Schema |
Description
---------------+---------+------------+---------------------------------------------------------------------
adminpack | 1.0 | pg_catalog | administrative functions for
PostgreSQL
btree_gist | 1.2 | public | support for indexing common
datatypes in GiST
cube | 1.2 | public | data type for multidimensional cubes
earthdistance | 1.1 | public | calculate great-circle distances on
the surface of the Earth
hstore | 1.4 | public | data type for storing sets of (key,
value) pairs
intarray | 1.2 | public | functions, operators, and index
support for 1-D arrays of integers
pgcrypto | 1.3 | public | cryptographic functions
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
plpythonu | 1.0 | pg_catalog | PL/PythonU untrusted procedural
language
postgis | 2.4.3 | public | PostGIS geometry, geography, and
raster spatial types and functions
(10 rows)
No tsearch2. I can't for the life of me figure out how to remove this so I
can upgrade to 10. Any tips?
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
@ 2018-03-28 05:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: Wells Oliver <wells.oliver@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2018-03-28 05:26 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Wells Oliver <wells.oliver@gmail.com> writes:
> I get that this library is no longer need. It's blowing up my upgrade to
> 10. Output:
> could not load library "$libdir/tsearch2": ERROR: could not access file
> "$libdir/tsearch2": No such file or directory
> But I can't see how or where this library is still installed. Running \dx
> on my database:
Did you check every database in the cluster?
If you did, then maybe you have some "loose" (pre-extensions) tsearch2
functions laying about somewhere. Look through pg_proc for functions
with probin = '$libdir/tsearch2'. Again, check every DB.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
@ 2018-03-28 16:15 Wells Oliver <wells.oliver@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Wells Oliver @ 2018-03-28 16:15 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org
Thanks. I ran: select * from pg_proc where probin like '%tsearch%';
This showed 38 functions. I believe I need to drop these, correct? However,
I am using to_tsvector() and to_tsquery(), but I believe these are now part
of the core postgres package, and I can safely drop these where probin
contains tsearch2. Am I correct, or do I need to rewrite things that use
to_tsvector()?
Thanks for any clarification.
On Tue, Mar 27, 2018 at 10:26 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Wells Oliver <wells.oliver@gmail.com> writes:
> > I get that this library is no longer need. It's blowing up my upgrade to
> > 10. Output:
> > could not load library "$libdir/tsearch2": ERROR: could not access file
> > "$libdir/tsearch2": No such file or directory
>
> > But I can't see how or where this library is still installed. Running \dx
> > on my database:
>
> Did you check every database in the cluster?
>
> If you did, then maybe you have some "loose" (pre-extensions) tsearch2
> functions laying about somewhere. Look through pg_proc for functions
> with probin = '$libdir/tsearch2'. Again, check every DB.
>
> regards, tom lane
>
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable...
@ 2018-03-28 17:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: Wells Oliver <wells.oliver@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2018-03-28 17:34 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Wells Oliver <wells.oliver@gmail.com> writes:
> Thanks. I ran: select * from pg_proc where probin like '%tsearch%';
> This showed 38 functions. I believe I need to drop these, correct? However,
> I am using to_tsvector() and to_tsquery(), but I believe these are now part
> of the core postgres package, and I can safely drop these where probin
> contains tsearch2.
If the DB doesn't complain when you try to drop them, you're good.
But the built-in ones would not have that in probin, anyway.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-03-28 17:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-28 04:53 postgres 9.6.8 to 10 on Ubuntu 16.04.4 LTS --- tsearch2 unloadable... Wells Oliver <wells.oliver@gmail.com>
2018-03-28 05:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-03-28 16:15 ` Wells Oliver <wells.oliver@gmail.com>
2018-03-28 17:34 ` 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