I just uploaded version 1.0 of RPgSQL. This is the final release (by me anyway). I've moved on to other things. Also, there is a more general R database api in the works (see Rdbi module in the RPgSQL CVS archive). I'm hoping someone will volunteer to maintain the package.
I've added a contributing HOWTO to the home page. See http://rpgsql.sourceforge.net/