Re: Database Migration Wizard

Hi Sarah,

The error you are seeing is almost certainly not caused by that SQL
query as that is a standard tried and tested query executed by the main
application to get statistics info. Can you please send me a complete
Full Debug log of the crash occuring? You can change the log level under
Tools -> Options.

Regards, Dave.

-----Original Message-----
From: Sarah Atkinson [mailto:Sarah(dot)Atkinson(at)lonelyplanet(dot)com(dot)au]

Sent: 26 March 2003 03:52
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Database Migration Wizard



Hello,

I am attempting to migrate a mysql database to postgres, via the
Database Migration Wizard.

I have setup the DSN on my XP workstation. I am able to test the
datasource and connect successfully.

However, when following the steps required to connect to the
datasource via the migration wizard (
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15) pgAdmin is
crashing on me. The logs show the following:

2003-03-26 14:44:30 - SQL (template1): SELECT datname,
numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM
pg_stat_database ORDER BY datname

FYI - I am using the mysql ODBC driver found at
http://www.mysql.com/downloads/download.php?file=Downloads%2FMyODBC3%2FM
yODBC-3.51.06.exe&pick=mirror

Any insight would be greatly appreciated.

Thanks,
Sarah.

Sarah Atkinson
Global Applications Team Leader

Lonely Planet Publications, Aust.
Telephone: +61 3 8379 8000
saraha(at)lonelyplanet(dot)com(dot)au <mailto:saraha(at)lonelyplanet(dot)com(dot)au>

______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.