Murali Mohan Kasetty <kasetty@india.hp.com> writes:
> \connect template1 Administrator
> CREATE DATABASE "CYCLE4" WITH TEMPLATE = template0 ENCODING = 'UNICODE';
> \connect CYCLE4 Administrator
I'm thinking that the problem is due to psql downcasing "Administrator"
to "administrator" --- note the spelling in the error message. Old
releases were pretty sloppy about quoting user names consistently in
dumps, so you might find that the easiest answer is just to edit the
dump file and change the usernames to be uniformly lower case.
regards, tom lane