Topics

User Functions

Events

There are no upcoming events

What's New

Stories

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Wednesday, May 22 2013 @ 06:13 PM EDT


 Forum Index > Support > Installation Support New Topic Post Reply
 Install using Postgres
   
mcyoung
 07/01/10 11:16AM (Read 1070 times)  
+----
Newbie

Status: offline


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.

 
Profile Email
 Quote
Dirk
 07/01/10 11:24AM  
AAAAA
Admin

Status: online


Registered: 01/12/02
Posts: 13027
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

 
Profile Email Website
 Quote
mcyoung
 07/01/10 12:17PM  
+----
Newbie
happy

Status: offline


Registered: 07/01/10
Posts: 4
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

 
Profile Email
 Quote
Dirk
 07/01/10 03:48PM  
AAAAA
Admin
embarrassed

Status: online


Registered: 01/12/02
Posts: 13027
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

 
Profile Email Website
 Quote
mcyoung
 07/02/10 08:15AM  
+----
Newbie
happy

Status: offline


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

 
Profile Email
 Quote
Dirk
 07/02/10 08:48AM  
AAAAA
Admin

Status: online


Registered: 01/12/02
Posts: 13027
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

 
Profile Email Website
 Quote
mcyoung
 07/02/10 09:22AM  
+----
Newbie

Status: offline


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

Thanks again.

 
Profile Email
 Quote
Content generated in: 1.88 seconds
New Topic Post Reply

Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content