PgAdmin question - superuser

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

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