Forum OpenACS Q&A: Re: freebsd 4.5 ports: pgdriver depending on postgres 7.3 breaks install

2: Re: freebsd 4.5 ports: pgdriver depending on postgres 7.3 breaks install (response to 1)

Posted by Don Baccus on 03/01/03 07:07 PM

Oh, jeez, whose bright idea was it to set it up with the user "pgsql"? The PostgreSQL docs use user postgres in their examples, that's where we've picked it up from.

I have no idea why it forced an upgrade to PG 7.3, but OpenACS 4 does not yet work correctly with it due to some non-backwards compatible changes in the semantics of the "timestamp" datatype (I'm working on fixing this today, as a matter of fact)

So you really want to uninstall 7.3 and go back to 7.2.4 now.

Why doesn't a dependency on postgres7 match postgres72? That makes no sense to me but then again, I'm old-fashioned, I just install PG from source and control my own world rather than let something like the ports system mess it up for me...

3: Re: freebsd 4.5 ports: pgdriver depending on postgres 7.3 breaks install (response to 2)

Posted by Tom Lazar on 03/01/03 07:20 PM

don wrote:

<blockquote>So you really want to uninstall 7.3 and go back to 7.2.4 now.
</blockquote>

first of all, thanks for the quick response!

now: i've done that already and 7.2.4 is running just fine (as user pgsql...)

at the moment i'm inclined to agree with you to forego the ports for installing postgresql and follow the instructions at openacs.org [1]

HOWEVER: these instructions don't mention anything of a pgdriver AT ALL?!

since you -- obviously -- have already successfully installed postgresql and openacs without using the ports collection, what would you suggest to do next?

again, thanks for your time!

tom