I need to switch from MySQL (where everything is peachy) to Postgresql - reason I need to switch is I need to use PostGIS and I don't see a need to run two databases.

I got Postgresql installed (stock CentOS / RHEL 5) and installed the postgresql php module and mdb2 driver. Restarted the web server.

Did a MySQL dump, ran it through a perl script, and managed to get it load into Postgresql without any apparent hickups. I can connect to postgresql and issue queries and expected results are in fact returned.

Made a user called webuser (what, you expect the real name to be disclosed here ??) in postgresql and gave it a password and access to the database. Updated the data/pg_hba.conf to add the following line:

local    mydbname webuser   127.0.0.1         password

restarted the postgresql server.

I *thought* that all I would then have to do is change my mdb2 dsn to reflect the new driver to use and then find parts of my code that are not standard enough SQL - but when I try to use anything, I get -

Fatal error: Call to undefined method MDB2_Error::execute() in /path/to/blah on line 63

I'm missing something here.

Here's my dsn -

$dsn = array(
   'phptype'  => 'pgsql',
   'username' => 'webuser',
   'password' => 'secret',
   'hostspec' => 'localhost',
   'database' => 'mydbname');

What am I doing wrong?
I get the same error no matter what I set username/password/hostspec/database to - so I think it is a basic connection error.

I'm hoping to be able to get the switch to postgresql finished soon so that I can start playing with using the PostGIS extension.

I'm running php 5.2.12 (my own build, based on Fedora src.rpm) w/ pear 1.8.1:

pear list
Installed packages, channel pear.php.net:
=========================================
Package           Version State
Archive_Tar       1.3.3   stable
Console_Getopt    1.2.3   stable
Date              1.4.7   stable
MDB2              2.4.1   stable
MDB2_Driver_mysql 1.4.1   stable
MDB2_Driver_pgsql 1.4.1   stable
PEAR              1.8.1   stable
Structures_Graph  1.0.2   stable
Text_Highlighter  0.7.1   beta
XML_Parser        1.3.2   stable
XML_RPC           1.5.1   stable
XML_Util          1.2.1   stable

Thanks for suggestions.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to