Last year I ported aD Shoppe to Postgres to demo an ecommerce site with OpenACS. The tarball is
here. It worked for me, but be warned - I haven't touched those sources since last June. Moreover, there *have* to be at least some queries that are still incorrect; I didn't need all the pages.
Shoot me an email when you hit a bug...