Thread: PgAdmin question - superuser

PgAdmin question - superuser

From
"Susan Lane"
Date:
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



Re: PgAdmin question - superuser

From
A_Schnabel@t-online.de (Andre Schnabel)
Date:
----- Original Message -----
From: "Susan Lane" <suel@dpn.com>
Subject: [GENERAL] PgAdmin question - superuser


> 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?

Yes PgAdmin builds some tables to it's own use. Therefore you have to be
superuser whe connecting the first time.





Re: PgAdmin question - superuser

From
Justin Clift
Date:
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