Re: Administrator issue - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Administrator issue
Date
Msg-id 20020924234308.A3705-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Administrator issue  (Murali Mohan Kasetty <kasetty@india.hp.com>)
List pgsql-general
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).



pgsql-general by date:

Previous
From: Murali Mohan Kasetty
Date:
Subject: Re: Administrator issue
Next
From: Adrian von Bidder
Date:
Subject: Re: OID order = INSERT order?