Re: Postgres passwords...

[Indraneel Majumdar <indraneel@xxxxxxxxxxxxxxx>]

one cool method is to use pg_passwd which is there on your system in the
bin directory of your postgres installation. Using pg_hba.conf is tricky
but possible.

\Indraneel

On Mon, 28 Aug 100, Ajay Dudani wrote:

> Hello...
> 
> so you just want have postgres password...
> simple..go to userconf and set a password for postgres..
> of simply  passwd postgres ..
> 
> then login as postgres user with that password and 'create user' ... let root
> or any other be the user and then work with it....
> 
> Ajay
> 
> 
> >Hi,
> >
> >How do I enable passwords for postgresql? I tried changing the 
> >pg_hba.conf, with the USERAUTH set to "password". Once I do it, it asks me
> >for password when I try running psql from $ prompt. But where do I set the
> >password??
> >
> >I tried logging in as postgres (the db admin), and updating pg_shadow
> >table, like this
> >
> >update pg_shadow set password='' where usename='';
> >
> >but after changing pg_hba.conf for password authentication, I can't use
> >the  as password for .. What is going wrong??
> >
> >I tried looking at postgres admin/user/programmar guides. But could not
> >find anything useful...
> >
> >TIA,
> >Kedar.
> >
> >
> >---------------------------------------------
> >The mailing list archives are available at
> >http://lists.linux-india.org/cgi-bin/wilma/LIP
> >
> >
> 
> ---------------------------------------------
> LIP is all for free speech.  But it was created
> for a purpose.  Violations of the rules of
> this list will result in stern action.
> 

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@xxxxxxxxxxxx  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/