Re: Switching Database Engines - Mailing list pgsql-general

From Carlos Mennens
Subject Re: Switching Database Engines
Date
Msg-id BANLkTimJfU+5cHOGrbbh9_zPR+Q+kDDrSA@mail.gmail.com
Whole thread Raw
In response to Re: Switching Database Engines  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Switching Database Engines  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-general
It seems that the 'mysql2postgres.pl' tool has instructions embedded
into the file so I ran the command as instructed to take the output
file and insert it into my PostgreSQL server and got the following
error message:

$ psql -p 5432 -h db1 -U wiki -f mediawiki_upgrade.pg
Password for user wiki:
BEGIN
SET
SET
SET
psql:mediawiki_upgrade.pg:25: ERROR:  relation "category" does not exist

Obviously this tool isn't written or supported by the Postgres
community but I figured I would ask in case someone understands this
and can advise me of a work around. If not it looks like this just
isn't going to work. :(

pgsql-general by date:

Previous
From: Thomas Larsen Wessel
Date:
Subject: Re: Converting between varchar and float when updating
Next
From: c k
Date:
Subject: Re: plpython module import errors