Re: Administrator issue

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Administrator issue
Date: 2002-09-25 06:44:35
Message-ID: 20020924234308.A3705-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian von Bidder 2002-09-25 06:48:13 Re: OID order = INSERT order?
Previous Message Murali Mohan Kasetty 2002-09-25 06:37:01 Re: Administrator issue