I have a system running Windows XPSP2, which has IIS 5.1. I installed PHP 5.1.2 using a combination of the installer and the zip file, in order to get the modules which are not installed by the .exe installer. I then dropped drupal 4.6.5 (with the directory renamed to "drupal") into my C:\Inetpub\wwwroot folder.

After mucking with postgres for a while (why aren't there postgres install instructions in the install document?) I got to the point where I can get this error:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation users in c:\Inetpub\wwwroot\drupal\includes\database.pgsql.inc on line 45

Fatal error: ERROR: permission denied for relation users query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'c2ab3a4e332de1d2361c8aaae022c3f3' AND u.status < 3 LIMIT 1 OFFSET 0 in c:\Inetpub\wwwroot\drupal\includes\database.pgsql.inc on line 62

Any input? I saw another person with this problem in the forums but there was no response, and there is no apparent documentation on drupal 4.6 and Postgres.

Comments

The user who connects to the database, can he SELECT things? I.e. does he have SELECT rights on the tables?

BTW, I'd advise you to use Drupal 4.7 (beta currently) with PostgreSQL.

--
Polska strona o Drupalu: http://drupal.cvbge.org