From: | Sam Carleton <ehc(at)linux-info(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | working with users |
Date: | 2003-10-15 01:10:52 |
Message-ID: | 20031015011052.GA8143@miltonstreet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ok, I am a newbie, but I simply cannot find anything in the
documentation so I hope you all are kind to me...
I have installed Postgres 7.3.4 (will reinstall once I get OpenSLL
compiled into it). I created the postgres user, and the first
database. As the postgress user, I am able to run psql and access
the database that I created. I have been able to run the create
user command.
But how do I see what users exist for the database? Because I was
the user postgres when I created the database, does that mean there
was a postgres user added during creation? If not, what user am I
when I run psql as postgres? If I am postgres, what is the password
to the database and how do I rest it?
Now I am not a DBA, but I have been around enough databases to know
that most of them have their own system tables. Does postgres have
system tables? If so, where do I find a list of them and their
usage?
Sam
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Carleton | 2003-10-15 01:17:16 | working with users |
Previous Message | j sk | 2003-10-15 00:58:21 | DELETE error - Memory exhausted in AllocSetAlloc |