Welcome to Geeklog Sunday, August 25 2019 @ 12:43 am EDT

Geeklog Forums

Install using Postgres


Status: offline

mcyoung

Forum User
Newbie
Registered: 01/07/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.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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

Status: offline

mcyoung

Forum User
Newbie
Registered: 01/07/10
Posts: 4
happy
Thanks for the quick response!

I've confirmed that the PHP install has Postgres support. I checked the output of:
PHP Formatted Code
phpinfo()

This returns true:
PHP 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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
embarrassed
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

Status: offline

mcyoung

Forum User
Newbie
Registered: 01/07/10
Posts: 4
happy
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.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

Status: offline

mcyoung

Forum User
Newbie
Registered: 01/07/10
Posts: 4
That was the problem.

Thanks again.

All times are EDT. The time is now 12:43 am.

  • 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