Re: how to separate database and web server ?

> I installed ogo on ubuntu 8.10 but I'd like to run the postgresql on a 
> separate server.
> I configured the postgres stuff on the new host, and ran the \i command 
> correctly.
> How can I tell  ogo to use another host for the database ?

You modify the LSConnectionDictionary in the NSGlobalDomain as
documented in the "Configuring The Database Connection" section of the
"PostgreSQL" chapter of WMOGAG (Whitemice Consulting OpenGroupware
Administrator's Guide).
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>

Basically -

Defaults write NSGlobalDomain \
  LSConnectionDictionary \
    '{ databaseName = *****;
       hostName = "*******";
       password = "*******";
       port = 5432;
       userName = ***** }'

If you are upgrading to PG 8.3 from an older version you should also
check out
<http://whitemiceconsulting.blogspot.com/2009/01/opengroupware-postgresql-8.html>  This is in WMOGAG as well in the FAQ section of the PostgreSQL chapter.  See: Operations on company objects (Contacts and Enterprises) fail
with a database exception of “ERROR: IN types character
varying and integer cannot be matched”

-- 
OpenGroupware developer: [email protected]
<http://whitemiceconsulting.blogspot.com/>
OpenGroupare & Cyrus IMAPd documenation @
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users