Forum OpenACS Q&A: Response to Anyone successfully using OpenACS/PostgreSQL/IRIX 6.2?

That's very odd.  Have you tried stepping through the driver to see how far it gets when you call "ns_pg" before crashing?