[lug] postgres

[Hugh Brown]

Thanks for the help.  It is plain text and there isn't much that can be
done about it.  I'm coming from a mysql background where there is a
mysql database that you can connect to and then list the tables there. 
The modus operandi of postgres is a fair bit different than mysql, so I
am going through some growing pains.  I also get the joy of trying to
figure out oracle over the next couple of days.  Wahoo.

I also discovered last night that the command \dS will list them and
then you can use the \ commands to describe them, etc.

Again thanks for the help everyone.

Hugh

On Thu, 2002-01-10 at 11:33, Evelyn Mitchell wrote:
> On Wed, Jan 09, 2002 at 10:53:06PM -0500, Hugh Brown wrote:
> > how does one access the system catalogs?
> 
> http://www.postgresql.org/idocs/index.php?pg-system-catalogs.html
> (I searched for 'system catalog' on postgresql.org, it's in
> the docs.) They are all tables. So to find out what databases 
> are available:
>   select * from pg_database;
> 
> > Also, is there a way to keep passwords from showing up in the file
> > pg_pwd in plaintext when they are set?
> 
> Don't know.
> 
> Evelyn Mitchell
> efm at tummy.com
> 
> > 
> > Hugh
> > 
> > 
> > On Wed, 2002-01-09 at 19:23, Evelyn Mitchell wrote:
> > > Hi Hugh,
> > > 
> > > Take a look at 
> > >   http://www.postgresql.org/idocs/index.php?client-authentication.html
> > > 
> > > It explains how to select different authentication methods.
> > > 
> > > You'll want to use "CREATE USER" and "ALTER USER" to manage
> > > the passwords. They should be stored in pg_shadow. 
> > > Then, the line in the pg_hba.conf file for that database
> > > should have an authtype of 'crypt' (to use encrypted passwords)
> > > or 'password' (to use plain text passwords).
> > > 
> > > Evelyn Mitchell
> > > efm at tummy.com
> > > 
> > > On Wed, Jan 09, 2002 at 06:42:09PM -0500, Hugh Brown wrote:
> > > > I am in a situation where I have to learn postgres admin.
> > > > 
> > > > I am beating my head against how it does user authentication.
> > > > 
> > > > If I create a user with a password it creates a file named pg_pwd in
> > > > $PGDATA/global but it stores it in clear text.  I can use pg_passwd
> > > > pg_shadow to create a username:password pair where the password is
> > > > stored crypt'ed.  How do I get postgres to look there rather than in the
> > > > pg_pwd file?
> > > > 
> > > > Hugh
> > > > -- 
> > > > ------------------------------------
> > > > System Administrator/Unix Consultant
> > > > hugh at vecna.com
> > > > Vecna Technologies, Inc
> > > > 6525 Belcrest Rd, Suite 612
> > > > Hyattsville MD, 20782
> > > > 301.864.7253
> > > > http://www.vecna.com
> > > > 
> > > > 
> > > > _______________________________________________
> > > > Web Page:  http://lug.boulder.co.us
> > > > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> > > _______________________________________________
> > > Web Page:  http://lug.boulder.co.us
> > > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> > 
> > 
> > _______________________________________________
> > Web Page:  http://lug.boulder.co.us
> > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
-- 
------------------------------------
System Administrator/Unix Consultant
hugh at vecna.com
Vecna Technologies, Inc
6525 Belcrest Rd, Suite 612
Hyattsville MD, 20782
301.864.7253
http://www.vecna.com