Re: Administrator issue

Hi Stephan,

Here is the extract of the dump file. CYCLE4 is the database name in the
first server.

--
-- pg_dumpall (7.1.3) -o
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE
datname = 'template0');

DELETE FROM pg_group;
--
-- Database CYCLE4
--
\connect template1 Administrator
CREATE DATABASE "CYCLE4" WITH TEMPLATE = template0 ENCODING = 'UNICODE';
\connect CYCLE4 Administrator
--
-- Selected TOC Entries:
--
--
-- TOC Entry ID 2 (OID 0)
--
-- Name: Max OID Type: <Init> Owner:
--

CREATE TEMPORARY TABLE pgdump_oid (dummy int4);
COPY pgdump_oid WITH OIDS FROM stdin;
629066 0
\.
DROP TABLE pgdump_oid;

\connect - Administrator

Thanks,
Murali

Stephan Szabo wrote:

> 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).