Due to the design of the database layer in Drupal 6 (and less) you can't mix different database engines (that feature is coming in D7).
My suggestion would be to dump the PostgreSQL DB and import it into a MySQL DB, then do the import. The other thing you could do is create your own PostgreSQL connector to use for the import, totally bypassing the Drupal database layer on that database.
Jamie Holly http://www.intoxination.net http://www.hollyit.net
On 1/25/2010 8:59 AM, Michel Morelli wrote:
Hi all. I need to import an old site (based on a proprietary CMS based on postgres) on drupal 6.x based on mysql.
I have thinked that two $db_url['XXX'] were enough, 1 (default) for mysql and the other (oldweb) for postgres.
But I receive this error when I try to use the connection to postgresql:
*Fatal error*: Cannot redeclare db_status_report() (previously declared in.......
How can I connect to an postgres db if my site run on mysql?
M.
Michel 'ZioBudda' Morellimichel@ziobuddalabs.net Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it JABBER:michel@ziobuddalabs.it