cryan wrote: The login function not existing is a sign that the database was not loaded correctly. The 2000+ errors on the restore is concerning. Some number of errors often occur for one reason or another but typically not that many. One thought is that perhaps you do not have installed or there is a problem with the plpgsql language. There are hundreds of plpgsql functions used for the application including the login function. If there was a problem with this then it could be why you received all those errors and why you can not log in.
If you could check to see if the plpgsql language is installed in the database in question and check to see if there are any plpgsql functions loaded that would either confirm or eliminate a potential problem. -- Read more at http://www.xtuple.org/phpBB2/viewtopic.php?t=2310