Just to add some more information, I've helped translate PostgreSQL and other projects, and my work was made easier by the availability of a non-connected translation.
On PostgreSQL's case, I just download the .po files from Peter Eisentreut's page, translate it, then send it back to him after checking them with GNU Gettext (I used kbabel for that, which really simplifies things).
-Roberto
