pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Wallick <tomwallick@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: How to enable automatic md5 password prompting when connecting to PostgreSQL
Date: Thu, 10 Mar 2005 22:51:14 -0800 (PST)
Message-ID: <20050311065114.30529.qmail@web54004.mail.yahoo.com> (raw)

How can I automatically have PostgreSQL prompt for a
password everytime I do the following to connect to my
sample databaase 'movies'?

I installed the database correctly to exact
instructions in the INSTALL doc in the PostgreSQL
source directory in /usr/local and it is now
registered as a daemon in the LINUX run level scripts
started when the system boots.


I assigned a password to the Administrator account
which is by default 'postgres' and to a second user (
the second was created with 'createuser tomwallick'
command which successfully echoed with the CREATE USER
message.

However, no password was issued for the new user
'tomwallick' when I initially created the user.

Then in the administrator handbook, I saw that I could
create a password after the fact with the ALTER USER
command.

I used md5 password authentication, rather than the un
encryped regular password athentication when issuing
the passwords for both 'postgres' and 'tomwallick'
users.

Here is how I did this, which works but I must pass
the -W flag to the psql command to startup the
database in order to be prompted to type in a
password. 

EXAMPLE:

psql -d movies -U tomwallick -W


I was simply expecting to simply just type:

EXAMPLE:

psql -d movies -U tomwallick

and as a result have the

password:

prompt request the password AUTOMATICALLY.

How can I clean/flush out the md5 passwords I
originally created and start over alter the two user
accounts 'postgres' and 'tomwallick' to simply have
regular password athentication. Keep in mind
'postgres' account is actually the administrator.

Or is it normal for my database to force me to type in
the -W flag to force me to enter in my password.





Help on this subject please.


Tom Wallick


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 



view thread (4+ messages)  latest in thread

Message-ID: <20050311065114.30529.qmail@web54004.mail.yahoo.com>
Permalink:  ../20050311065114.30529.qmail@web54004.mail.yahoo.com/
Also on:    postgresql.org/message-id/20050311065114.30529.qmail@web54004.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tomwallick@yahoo.com
  Subject: Re: How to enable automatic md5 password prompting when connecting to PostgreSQL
  In-Reply-To: <20050311065114.30529.qmail@web54004.mail.yahoo.com>
  References: <20050311065114.30529.qmail@web54004.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox