From: | "Robert John Shepherd" <robert(at)reviewer(dot)co(dot)uk> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Restoring a db dump with tsearch fields fails |
Date: | 2002-11-08 01:29:32 |
Message-ID: | 001501c286c6$5a14bbb0$f3b0313e@LAIKA |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bit of a problem here, am regularly backing up my database with
pg_dumpall, which works fine.
However when I attempt a restore on another box, things go rather
pearshaped, and I'm pretty sure this is because I am using tsearch from
the contrib directory.
I've tried adding tsearch.sql to the template1 db, in case that helped,
which it didn't. :/
I get lots of these during the restore:
ERROR: parser: parse error at or near "ikebe"
ERROR: parser: parse error at or near "'"
ERROR: parser: parse error at or near "ne"
ERROR: parser: parse error at or near "'"
ERROR: parser: parse error at or near "ad"
ERROR: parser: parse error at or near "phane"
ERROR: parser: parse error at or near "rgaard"
ERROR: parser: parse error at or near "gnes"
ERROR: parser: parse error at or near "e"
ERROR: parser: parse error at or near "otis"
ERROR: parser: parse error at or near "gis"
ERROR: parser: parse error at or near "rald"
Query buffer reset (cleared).
invalid command \n
Query buffer reset (cleared).
invalid command \n<p
Query buffer reset (cleared).
invalid command \n<p
Query buffer reset (cleared).
invalid command \n<p
Query buffer reset (cleared).
I'm presuming all of these relate to the way pg_dump creates scripts for
the tsearch fields.
This could make restoring my database rather tricky if I ever have to do
this for real. :o
Anyone have any suggestions?
Yours Unwhettedly,
Robert John Shepherd.
Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk
For a copy of my Public PGP key, email: pgp(at)robertsworld(dot)org(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-11-08 01:36:43 | Re: [HACKERS] Database replication... - Mission Critica |
Previous Message | Lamar Owen | 2002-11-08 01:24:04 | Re: Hardware estimation |