Sign up ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.

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

http://pgedit.com/install_drupal

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?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

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.

share|improve this answer

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

share|improve this answer
    
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 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 at 6:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.