All page names need to be in English.
en da  de  fr  it  ja  km  nl  ru  zh

warning - Message

Important notice: This wiki is scheduled to be disabled in 2021. We are in the process of migrating content to the official documentation on If you find information here that is missing from the official documentation, please feel free to get in contact with us on TYPO3 Slack (Channel: #t3docs-sig-wiki-migration).


From TYPO3Wiki
Jump to navigation Jump to search

What do I need for PostgreSQL?


TYPO3 makes use of a few features only found in PostgreSQL 9.0 and newer. It is recommended that you use the latest released major version. You can install the PostgreSQL DBMS package included in your Linux Distribution, use one of the pre-built binary packages provided by the PostgreSQL team or use the EnterpriseDB provided downloads.


PHP 5.5+ with support for PostgreSQL. All major Linux distributions include the required drivers, as should MAMP and XAMPP.


It is advised to use the latest development master as a lot of work is happening on the DBAL at the moment. If you need to use released version TYPO3 7.3 or later is advised.

How do I configure my system


You must install at least one of these extensions by adding them to your php.ini.

  • pgsql
  • pdo_pgsql



; configuration for php PostgreSQL module


; configuration for php PostgreSQL module


The current installer supports using the DBAL during first install. Most PostgreSQL installations are set up to connect using a TCP/IP network connection with user authentication, if you can't connect using the socket it is advisable to switch the connection type.


The database should be create with a UTF-8 collation, for example by using the following command: createdb typo3 -EUTF-8. After the database has been created the MySQL compatibility operators need to be installed. The necessary SQL dump is included with the TYPO3 source and can be found at typo3/sysext/dbal/res/postgresql/postgresql-compatibility.sql.


For core development and reviewing patches a box for Vagrant can be used. To get started use the following Vagrantfile:

Create a Vagrantfile

 Vagrant.configure(2) do |config| = 'mojocode/typo3'
   config.vm.box_url = ''
   config.vm.box_version = '~> 1.0'
   config.vm.box_check_update = true 'private_network', ip: ''
   config.vm.synced_folder 'Web', '/var/www'
   config.vm.provider 'virtualbox' do |vb|
     vb.memory = 2048
     vb.cpus   = 2

Install TYPO3 sources

Add a TYPO3 first install setup in a subdirectory called Web in the same directory where the Vagrantfile is.

Provision the virtual machine

 $ vagrant up

Create a database

 $ vagrant ssh
 $ createdb typo3 -EUTF-8

Perform TYPO3 first install

Open in your browser and configure TYPO3 with PostgreSQL.

Database connection parameters

Parameter                     | Value
User                          | vagrant
Password                      | vagrant
Host                          |
Port                          | 5432
Database                      | typo3