I was following the tutorial in the link below to install Drupal 7 with PostgreSQL.


I'm stuck with step 3.

3.Load the Drupal database schema

Your Drupal installation has a top level folder called 'database' where you will find an installation script called 'database.pgsql'. Simply run the script with psql:

psql -U test_drupal -f /path/to/drupal/database/database.pgsql

In my case I cant find database.pgsql. My database folder only contains files shown in the image below:

enter image description here

|Im using drupal7.34. Where am I possibly missing?


I am not sure this tutorial is up-to-date. You don't need to load database scheme, you can just choose to use PostgreSQL when running the installer at /path/to/drupal/install.php

  • I have tried what you said. I run localhost/drupal/install.php but there is no available "PostgreSQL" option in the Database Type. Available options are only *MySQL,MariaDB or equivalent and *SQLite. – user34776 Mar 18 '15 at 0:31
  • 1
    Well, is PostgreSQL installed and running on your machine? Here's my screenshot from my local dev environment: i.imgur.com/qNic5Mm.png It clearly shows the PostgreSQL option, I am running PostgreSQL 9.3 locally. – Paul Mar 19 '15 at 6:37

There are two PostgreSQL extensions in PHP. One is called pgsql which is the old version. Drupal 6 runs on this. The other is pdo_pgsql. Drupal 7 requires this.

This is what I have enabled in my php.ini to make PostgreSQL an available option to use when installing Drupal.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy