Migrating the database using pg_dump and pg_restore does not guarantee the migration of the database user. Is it possible that you've got the database migrated but not the database user?
If you do this on a database-by-database method, then agreed, logically you might run the risk.
However, if you do a pg_dumpall into a one file, all of those roles travel.
When you do the restore, you restore all users, functions, procedures, databases, tables, etc.
I would leave drupal out for a minute and make sure that you can connect to the database using the pg_admin tool or something like it using the user that you connect with for drupal. (Us psql -h hostname or something) to make sure you are not using a local user, but rather a remote one.
Good suggestion. I can work with the database from the command line using Postgresql's command line monitor (very much like MySQL's).
What does this test yield?
News at 10.
I'll test this; putting out other fires now.
FYI: civicrm is a drupal distribution/module. You'd know if you had it. Sorry for the red herring.
No problem.
Thanks for the suggestions.
Max