On 25 Sep 2002 at 11:31, 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
Looks like you are different OS users on the third machine. Try using psql -u
and specify appropriate uername/password..
HTH
Bye
Shridhar
--
share, n.: To give in, endure humiliation.