In dumping from one 7.1.2 install and trying to restore in another fresh install: You are now connected to database template1. DELETE 0 psql:/local/dumpall-8-14:7: ERROR: CREATE USER: sysid 101 is already assigned CREATE USER DELETE 0 You are now connected to database template1 as user postgres. CREATE DATABASE You are now connected to database <mydb> as user postgres. psql:/local/dumpall-8-14:22: \connect: FATAL 1: user "<username-goes-here>" does not exist -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
