Well it's failing on line one of your dump file, which is trying to connect to your database. Did you do a "createuser nsadmin" on your new database? Since it can't connect everything past it is not going to run.
The mystery here is how did the table schema get loaded? If it failed to connect on the first line of the dump file there should be *nothing* ...
