On Wed, 25 Sep 2002, Murali Mohan Kasetty wrote:
> Hi ,
>
> I'm trying to dump the data form one postgreySQL 7.1.3 server to
> another postgreySQL 7.1.3 server.
> I have used pg_dumpall command to dump the data, I'm able to dump the
> data in the second server successfully.
> However, when I try to dump the same data in 3rd postgreySQL 7.1.3 , the
> dump is failed and I get the following error message.
>
> You are now connected to database template1.
> DELETE 0
> DELETE 0
> \connect: FATAL 1: user "administrator" does not exist
Can you find the associated create users for the administrator
account in the dump file and the failing connect line?
I wonder if it was insufficiently careful to quote the user
name somewhere (like the connect line).