Oh, yeah, you just need to configure you "good old init .tcl file". I'm even using the three old pool names in mine, I'm so lazy (main, subquery, log).
I've not gotten around to looking at the "official" new nsd-oracle.tcl file to put together a better example for PG.
As far as psql goes ... if your database is on another machine and running -i, I *think* you can configure psql to automatically reference it by clever setting of environment variables but I've never tried it. I think that would be the least confusing way to do things, so running psql in whatever account is passed with the -u switch to opennsd accesses your openacs database.
You may have to do it via switches to configure when building PG. I know you can specify the port this way, for instance, and I've done so in my installation. I assume you can specify the IP as well as the port when you build ...
