Hi Sridhar,
The 3rd Server has no users, the only user is Administrator (I think it
comes by default).
So, I just started the server and tried to dump the data then I got the error
message as I said in my previous mail.
Please let me know if you have any pointers.
Thanks,
Murali
Shridhar Daithankar wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html