donators

n@work Internet Informationssysteme GmbH
Your ad here

supported by

 TYPO3 Hamburg
 TYPO3 Anbieter

support @ Amazon

If you like to support this site and you want to by something at Amazon, please use this link for purchasing your desired items. This does not cost you anything more than the normal price but I got a small revenue from your order.
Thank you!

Advertising

print page print page

Short DBAL how-to

By: Thomas

13.04.07 16:12 Age: 1 yrs

This very short how-to shows you how you can setup a TYPO3 Installation that runs with DBAL on a postgreSQL database.

It's highly recommend, that you use this to start from cratch. This is NO tutorial how to migrate any existing site to another database!

Step 1

Install TYPO3 as usual with a normal mysql database

Step 2

Log into the system and install the extensions "adodb" and "dbal". These extension are delivered with the TYPO3 source package.

Step 3

Log into your postgreSQL database and create a new database. In this case the database is called "typo3_db". You should also create user that has access to the new database.

You can try to create the database from within the install tool. But I don't know if that works. I didn't tried it.

Step 4

After you have created the database. Go to the console and edit the localconf.php in your typo3conf folder.

Here you have to configure which driver should be used for the default database. Your code could look like this:

  1.  

  2. $TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (

  3.         '_DEFAULT' => array (

  4.                 'type' => 'adodb',

  5.                 'config' => array (

  6.                         'driver' => 'postgres7',

  7.                 )

  8.         )

  9. );

  10.  

  11. $typo_db_username = 'typo3';

  12. $typo_db_password = 'typo3';

  13. $typo_db_host = 'localhost';

  14. $typo_db = 'typo3_db';

  15.  

For a detailed description of the properties, read the DBAl manual.

Step 5

No start the installer and go to the "Database analyser" and click on "Compare". After executing the operations, you can also import some static data if you need that. If not you are done, and your TYPO3 installation should run on postgreSQL.

Links:

DBAL Manual

adodb Manual / Drivers section

Back to: Cookbook

Found a mistake?

If you found a mistake or if you have a good tip or suggestion, please contact me at thomas(at)typo3-unleashed.net. I will check it and correct the entry or insert the new one.

Thanks in advance for your help.