From: Nick Fankhauser <nickf@ontko.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Cc: Ray Ontko <rayo@ontko.com>
Subject: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
Date: Fri, 10 May 2002 09:11:57 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGMEBPEPAA.nickf@ontko.com> (raw)
Hi-
The background info:
Debian 2.4.14 on both source & destination boxes
PostgreSQL 7.1.3 on source
PostgreSQL 7.2.1-2 on destination
We are testing 7.2 with our application by installing it on a separate box &
accessing it via the network. The 7.2 install is just a plain vanilla
install using the Debian package which went well. (Well done, as usual
Oliver!)
The export of data from the old system was simply a pg_dumpall, and the
import was a load of the dump file using psql and an empty newly created
database.
The load returned two errors that I don't understand:
(1)
ERROR: DefineIndex: index function must be marked iscachable
unfortunately, I don't know which line of the dumpfile we were on when this
occurred, but It only happened once, and the only indexes I can think of
that might be different from the rest are functional indexes. One of them is
an index on upper(field), and the other is based on a function defined in
psql that uses the translate function.
(2)
ERROR: cannot find attribute 1 of relation schedule_notification_log
ERROR: cannot find attribute 1 of relation schedule_notification_log
We got this one twice, just as shown above. When I do a \d
schedule_notification_log, I get this result:
develop=# \d schedule_notification_log
Table "schedule_notification_log"
Column | Type | Modifiers
--------+------+-----------
Other than these errors, the data migration went very smoothly, and our
applications have functioned at least partially without modification. We
haven't been able to test thoroughly yet, because a few queries are very
slow, and the second error above seems to keep vacuum analyze from running
as well.
Any thoughts on these errors are appreciated.
Regards,
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: nickf@ontko.com, rayo@ontko.com
Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGMEBPEPAA.nickf@ontko.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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