Posted on: 07/01/10 11:16am
By: mcyoung
I'm attempting to do a new install of version 1.7.0, and I'd like to have Postgres as my underlying DBMS. When I run .../admin/install/index.php Postgres is not an option. I do have Postgres installed and running on the server, and I've created a new database for my geeklog site.
I've noticed that there is not a file, postgres_tableanddata.php, under the 'sql' directory, and that there is not a file, postgres.class.php, under the 'system/databases' directory.
Was this feature postponed for another release?
Thank you.
Re: Install using Postgres
Posted on: 07/01/10 11:24am
By: Dirk
The files are actually called pgsql_tableanddata.php etc. - check if those are present.
The installer does a few checks to see if your system supports Postgres. It checks for the above files and whether your PHP has a pg_connect function built in. So if the files are there, check that you have a PHP install that includes Postgres support.
bye, Dirk
Re: Install using Postgres
Posted on: 07/01/10 12:17pm
By: mcyoung
Thanks for the quick response!
I've confirmed that the PHP install has Postgres support. I checked the output of:
Text Formatted Code
phpinfo()
This returns true:
Text Formatted Code
function_exists("pg_connect")
I just re-downloaded the 1.7.0 tarball to double check, and I'm not seeing the pgsql tableanddata or class files. I'm new to this so I may not know where to look. However, they are not siblings to the mysql and mssql versions.
Thanks for your help,
Mark
Re: Install using Postgres
Posted on: 07/01/10 03:48pm
By: Dirk
Quote by: mcyoungI just re-downloaded the 1.7.0 tarball to double check, and I'm not seeing the pgsql tableanddata or class files.
Oh wow, you're right. How embarrassing is that? They were indeed missing from the 1.7.0 tarball. That's what happens when you only test directly from the repository ...
I've updated the tarball now to include the 2 missing files (no other changes). New file size is 5177871 bytes, md5 checksum c73865f5acde0bf3160f70f8a82bb42b
Thanks for the report and sorry about that.
bye, Dirk
Re: Install using Postgres
Posted on: 07/02/10 08:15am
By: mcyoung
Sorry to be a pain. I'm just looking forward to getting started, and I prefer Postgres.
The file I'm getting from the download page has the original check sum, and does not seem to have the pgsql files.
Re: Install using Postgres
Posted on: 07/02/10 08:48am
By: Dirk
I just tried it and got the new one. It's probably cached somewhere on your side. Try emptying your browser's cache.
bye, Dirk
Re: Install using Postgres
Posted on: 07/02/10 09:22am
By: mcyoung
That was the problem.
Thanks again.