Re: PgAdmin question - superuser - Mailing list pgsql-general

From Justin Clift
Subject Re: PgAdmin question - superuser
Date
Msg-id 3B90C80D.6ACBFA6F@postgresql.org
Whole thread Raw
In response to PgAdmin question - superuser  ("Susan Lane" <suel@dpn.com>)
List pgsql-general
Hi Susan,

PgAdmin stores information about the database in pgadmin_* tables in the
database itself.  It creates these tables the first time it connects,
and this is why you need to log in as the PostgreSQL supervisor first
time around.

Hope thats helpful.

:-)

Regards and best wishes,

Justin Clift

Susan Lane wrote:
>
> Hi -
>
> I set up a user and database using psql.  Then when I added the DSN
> connection for PgAdmin and tried it out with my new user id, it told me I
> had to log in as superuser.  So, I did.  Then I disconnected and logged in
> again as the new user I had created.  The second time, it worked.  Anybody
> know what happens behind the scenes that makes you log in as superuser the
> first time?  Is there some kind of initialization going on?
>
> --
> Susan Lane
> DPN, Incorporated
> 4631 Spring Mountain Road
> Las Vegas, NV 89102
> Email  suel@dpn.com
> Ph. (702) 873-3282
> Fax (702) 873-3913
> http://www.dpn.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
     - Indira Gandhi

pgsql-general by date:

Previous
From: Gunnar Rønning
Date:
Subject: Re: [WAY OT] Re: PL/java?
Next
From: Justin Clift
Date:
Subject: Re: Apache authentication