I've been working on Postgres this morning, trying to find a way to export my Drupal data in a format that is useful on Bluehost. This pg_dump command comes fairly close, but the primary keys are getting mangled which is causing a bit of a problem.
pg_dump -O --no-acl --disable-dollar-quoting neworder1 |gzip >neworder1.sql1.gz
Postgres on Bluehost is restricted from seeing any of the Postgres system tables. If I can't find a workaround I'll have to re-create my databases from scratch.