Michael,
In terms of the errors you are getting when attempting to restore a dump from the older server to the new server, I can give you some advice.

1) On the old server, when you run pgdump, make sure you specify the "--format=c" option

2) On the new server, you will need to add the roles that are in use on the old server. To add a new role to your new server, you can run the following from the command line

  createuser --superuser ROLENAME

do this for each role you need to create

3) On the new server, lets use a different database from the one your currently have configured, so you will need to create a new database by running the following from the command line
  
  createdb NEWDBNAME

4) On the new server perform the restore by running the command

  pg_restore -d NEWDBNAME --format=c DB_BACKUP_FILE


If you experience any errors during the restore such as "role does not exist' etc. Then stop the restore, drop the NEWDBNAME database (run command dropdb NEWDBNAME), create NEWDBNAME database again, fix the problem (ie if you are missing a role, create the new role ) and then try the restore command again.


When the restore has completed successfully, you can simply edit your labkey.xml configuration file to point to the new database and restart the LabKey Server.


I hope this helps.

-Brian