PostgreSql installation problems

You likely will be for a while. If you keep pushing back any fixes or bubbling up problems, we'll extend the subscription for a while more... likely not forever, but will do another 3 months when this period is almost up.

Having Postgres support is helping us, actually, as well. It's cleaning up some of our queries to make them more generic and making us analyze things a little differently. It also makes us a small hop away from adding MSSQL and other database support, which can help grow things a little.. not huge markets, but still good to promote too.

As for Postgres in general, do you mind letting us know why you chose it? Was it just what your server came with, or what you prefer to work with? Would love to hear your background and thoughts on it. It's definitely more strict than MySQL, which has it's advantages, but still not something commonly used.

Oh yeah, the v5.2.2 release slipped and should be out today. Had a few minor hiccups at the end of last week that pushed it back.

Thanks,
Alex

Thanks for the explanation. I think MySQL can honestly scale past 1Gig databases pretty easily (we've seen that in the past on some of our own projects). Beyond that though, Postgres does have some stability features that I will agree with. I haven't looked into their memory footprint, but will have to evaluate more.

I appreciate the info.. will be good to look into more. As for Joomla support, it's seemed to be pretty stable on our testing of Postgres. Have you found decent extension compatibility as well? Hope you don't mind the questions!

Thanks again,
Alex

Using the least amount of extensions necessary is always a good way to go. Less conflicts, less 'migration' issues, and less extra stuff to make sure is up to date (and not insecure).

Interesting to hear you've been on Mambo for 10 years. Crazy! I've never even used Mambo. I started with Joomla right at the 1.0 -> 1.5 transition, so mostly got my feet wet with 1.5 and never adjusted/liked 1.0.

Anyways, I'm glad to hear that JFBConnect is working well for you on your site and Postgres. We'll be testing with it going forward, but won't have our automated suite of tests running on it for some time. That means that it's possible that a bug or 2 may creep in here or there.. the good news is that they should be easy to fix when/if that happens.

Thanks again for all the feedback. It's been very appreciated!
Alex

Fantastic! Thanks, as always, for the feedback. With all the updates to our DB queries, we were concerned that something may break in Postgres or MySQL. So far, just one minor error, and nothing that would require a new release for it yet... whew!

Best of luck,
Alex

Can you let me know what change you made to the module that fixed that issue? I'm a bit confused on how those links are causing a database error. The SCLogin module (and JFBConnect for that matter) don't process the "Forgot xyz" links. We just create links that go to the Joomla User component. When clicked, the user is interacting with core Joomla, not our module or component.

We'll gladly investigate, just can't figure out where to begin on this one.

Thanks,
Alex