Forum OpenACS Development: Re: Rewrite of the .sql files of acs-core and some commonly used packages
i am not sure, where in the api-browser you are exactly looking at, but you should be aware, that (a) not all packages are updated to the dollar-quoted syntax, and that (b) not all of the installed functions are changed in case of upgrading from older installations.
What's still missing are more upgrade scripts to make sure, that all define_function_args on all core packages are on the same level for upgrades and new installations.
Concerning the postgres config files for pg9.2: one can use the stock postgres config files, no modifications are required. This make life easier, when binary distributions are used. One might want to tune it, but this is optional.