ation missing while migration from
8.3 to 9.4
Julie Nishimura writes:
Thank you guys. I've dumped the schema and was able to load it properly this
time. There were some missing text search dictionaries, fts templates and
functions. I was able to recreate it. Now is my question - do I need
Julie Nishimura writes:
> Thank you. Is there a way to find out if I have tables with tsvectors or
> indexes? I have hundreds of tables...
Search the system catalogs. I'd probably do it like this:
select attrelid::regclass, attname from pg_attribute
where atttypid = 'tsvector'::regtype;
but
configuration missing while migration from 8.3 to 9.4
Julie Nishimura writes:
> Thank you guys. I've dumped the schema and was able to load it properly this
> time. There were some missing text search dictionaries, fts templates and
> functions. I was able to recreate it. Now
Julie Nishimura writes:
> Thank you guys. I've dumped the schema and was able to load it properly this
> time. There were some missing text search dictionaries, fts templates and
> functions. I was able to recreate it. Now is my question - do I need to
> reload the data?
The base textual data
From: Adrian Klaver
Sent: Tuesday, April 16, 2019 5:14 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: text search configuration missing while migration from 8.3 to 9.4
On 4/16/19 4:22 PM, Julie Nishimura wrote:
> Adrian, Hitwise is the name of our company. Unfortunately, it
On 4/16/19 4:22 PM, Julie Nishimura wrote:
Adrian, Hitwise is the name of our company. Unfortunately, it does not
help to find how I can migrate missing search config or install whatever
is on 8.3. I did not restore the entire database (due to its large
size), I've dumped and restored just abou
.html
*From:* Adrian Klaver
*Sent:* Tuesday, April 16, 2019 3:08 PM
*To:* Julie Nishimura; pgsql-general@lists.postgresql.org
*Subject:* Re: text search configuration missing while migration from
8.3 to 9.4
On 4/16/19 1:55 PM, Julie Nishimura wrote:
Oh thank you for answering me!!!
An
aging. Perhaps, some
functions need to be migrated as well, just do not know where to look...
From: Adrian Klaver
Sent: Tuesday, April 16, 2019 3:08 PM
To: Julie Nishimura; pgsql-general@lists.postgresql.org
Subject: Re: text search configuration missing
On 4/16/19 1:55 PM, Julie Nishimura wrote:
Oh thank you for answering me!!!
Another thing:
source (8.3):
\dF
List of text search configurations
Schema | Name | Description
++---
On 4/16/19 2:46 PM, Tom Lane wrote:
Julie Nishimura writes:
1) This is the 8.3 source:
select * from pg_ts_dict;
...
english_stem_nostop | 21960 |10 |11282 | language =
'english'
hwsplit | 21960 |10 |22342 |
hwsplit_only
Julie Nishimura writes:
> 1) This is the 8.3 source:
> select * from pg_ts_dict;
> ...
> english_stem_nostop | 21960 |10 |11282 | language =
> 'english'
> hwsplit | 21960 |10 |22342 |
> hwsplit_only| 21960 |10
ult configuration for text search
default_text_search_config = 'pg_catalog.english'
Unfortunately, I am not sure about tsearch2, it is new system that I inherited
not too long ago. So, the production is still on 8.3, but dev/staging that was
built recently, is on 9.4. The engineer who i
On 4/16/19 12:02 PM, Julie Nishimura wrote:
Correction: tables are not missing, but some records from the tables
missing. How can we migrate them properly from 8.3 to 9.4?
This is going to need some more info:
1) What records?
2) 8.3 was the version where text search was integrated into core.
Correction: tables are not missing, but some records from the tables missing.
How can we migrate them properly from 8.3 to 9.4?
Sent from my iPhone
On Apr 16, 2019, at 10:32 AM, Julie Nishimura
mailto:juliez...@hotmail.com>> wrote:
Hello, we recenlty created fresh install of 9.4, created new d
14 matches
Mail list logo
