If you are wanting Postgres in a tiki like environment, then I really recommend you use http://tikipro.org instead. There is no active Postgres developer at the moment in Tiki community, and many postgres problems still exist with indexes and the like.
Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.