Actually ... David Walker's solution is a good one and needs to be snarfed for the documentation.  Apparently alter user doesn't modify pg_shadow, which is why it doesn't work.

Jowell ... after the datamodel's loaded, there should be no need for the database user to have PG superuser rights, and in PG 7.2 shouldn't even be needed to load the datamodel.

I hope, at least.