From: | Ahmed Ossama <ahmed(at)aossama(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | adrian(dot)klaver(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error during a dump (ts_selectivity, not found) |
Date: | 2011-01-19 17:44:57 |
Message-ID: | 4D372319.2060109@aossama.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks a lot Adrian and Tom.
Like Tom said, I suspected that I was dealing with a third party extension.
I have no problems with the restore without them, and the restore goes
fine, but it stops and the point:
"WARNING: errors ignored on restore: 6"
The database is 60GB and it stops at 47GB. So could this extension be
the reason behind the failure?
I don't see anything in the logs for more details about this error.
Best Regards,
Ahmed Ossama
On 19/01/2011 18:10, Tom Lane wrote:
> Adrian Klaver<adrian(dot)klaver(at)gmail(dot)com> writes:
>> On Wednesday 19 January 2011 4:57:42 am Ahmed Ossama wrote:
>>> I searched for the library ts_selectivity, but all in vain.
>> Are you by any chance trying to restore a dump taken from a pre-8.3 server with
>> Full Text Search to 8.3+ one? If so in 8.3 Full Text Search moved from being a
>> contrib module to being integrated in the server.
> That was never called "ts_selectivity", though. Ahmed must be dealing
> with some third-party extension module. There's no such module in
> pgfoundry, nor has Google ever heard of it, so I'm thinking it was
> privately written code.
>
> Do you really *need* to restore those objects? If you just ignore the
> errors, you'll get a restore without the custom functions ... but if you
> don't know what they are, maybe you don't need them anymore.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2011-01-19 17:49:55 | Re: Need help writing exclusion constraint |
Previous Message | Andreas Kretschmer | 2011-01-19 17:43:43 | possible error in documentation for 9.1 |