Welcome to Geeklog, Anonymous Tuesday, October 08 2024 @ 11:26 pm EDT
Geeklog Forums
Install using Postgres
Status: offline
mcyoung
Forum User
Newbie
Registered: 07/01/10
Posts: 4
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.
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.
8
5
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
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
6
6
Quote
Thanks for the quick response!
I've confirmed that the PHP install has Postgres support. I checked the output of:
This returns true:
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
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
4
8
Quote
Quote by: mcyoung
I 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
9
9
Quote
All times are EDT. The time is now 11:26 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content