Friday, September 25, 2009

Postgres 8.3 error: Internal account lookup failure: no mapping between account names and security IDs was done

If you have encountered this error on a Windows XP machine, check to see if your machine name in the 'Account Domain' field (in the PostgreSQL installer GUI) is correct.

If you are pulling up the GUI through the command line which has the servicedomain='' parameter, your 'Account Domain' field will be populated to have the value ''. This is obviously erroneous because of the single quotes in the value.

It would be best to not specify the servicedomain='' parameter. Postgres usually pre-fills the 'Account Domain' field correctly.

2 comments:

Thank you for your comment.