Hi All,
I have been running dbmail 1.2.10 (pg 7.3.4-11) for a while now, but the
machine I am running on is getting flaky, so I want to upgrade the
hardware. I thought I'd update to dbmail 2.0.4 (pg 7.3.4-11) at the same
time.
I dumped the database with :
pg_dump -f dbmail.all -C dbmail
then load with pgsql -U dbmail < dbmail.all
When I run the migrate script I get:
I get the following output:
dbmail=# \i migrate_from_1.x_to_2.0.pgsql
BEGIN
psql:migrate_from_1.x_to_2.0.pgsql:28: ERROR: Relation
'auto_notification_seq' already exists
psql:migrate_from_1.x_to_2.0.pgsql:33: ERROR: current transaction is
aborted, queries ignored until end of transaction block
psql:migrate_from_1.x_to_2.0.pgsql:35: ERROR: current transaction is
aborted, queries ignored until end of transaction block
psql:migrate_from_1.x_to_2.0.pgsql:40: ERROR: current transaction is
aborted, queries ignored until end of transaction block
COMMIT
BEGIN
DROP INDEX
DROP INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
DROP INDEX
psql:migrate_from_1.x_to_2.0.pgsql:61: NOTICE: constraint $1 on table
mailboxes depends on index users_id_idx
psql:migrate_from_1.x_to_2.0.pgsql:61: ERROR: Cannot drop index
users_id_idx because other objects depend on it
Use DROP ... CASCADE to drop the dependent objects too
psql:migrate_from_1.x_to_2.0.pgsql:62: ERROR: current transaction is
aborted, queries ignored until end of transaction block
psql:migrate_from_1.x_to_2.0.pgsql:63: ERROR: current transaction is
aborted, queries ignored until end of transaction block
psql:migrate_from_1.x_to_2.0.pgsql:64: ERROR: current transaction is
aborted, queries ignored until end of transaction block
:
:
Any ideas?
--
Regards,
Colin Manning B.Sc.
Systems Consultant
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN: 61 108 296 288
