[support] Authentication problem, was Re: Recent move Drupal 6.22, PHP5.3, PostGresql 8.4 doesn't work - continuing

[Max Pyziur]

> 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