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.klaver@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
