Re: Auth users and command pg_passwd - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Auth users and command pg_passwd
Date
Msg-id 200302141240.h1ECejT04018@candle.pha.pa.us
Whole thread Raw
In response to Re: Auth users and command pg_passwd  (TooManySecrets <toomany@toomany.net>)
List pgsql-admin
You can assign the password as part of createuser, and it is stored
encrypted in the database.

---------------------------------------------------------------------------

TooManySecrets wrote:
[ PGP not available, raw data follows ]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thursday 13 February 2003 20:34, Bruce Momjian wrote:
> > pg_password is gone.  Few were using it, and now we encrypt the
> > passwords stored in pg_shadow.  Were you sharing your /etc/password file
> > with PostgreSQL, or did you have another reason for using pg_password?
>
> Not. I before was creating a user with the command "createuser", and then,
> like as user "postgres", was executing the command " pg_passwd data/passwd ",
> where one was guarding the user and his key encripted. Hereby, in the file
> "pg_hba.conf", it was had by place (the authentication ) this way:
> password/var/lib/data/passwd
>
> I will study more held up the documentation.
>
> Thank you very much.
>
> - --
> Have a nice day ;-)
> TooManySecrets
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (FreeBSD)
>
> iD8DBQE+TKLyICNFwaoqbY8RAqcKAJ9ghIexbX9XMryJkUy2MRA/Mr9ngACeLx8V
> lNKlsSlaKTPVWj+6gED8Tkk=
> =ismN
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
[ End of raw data]

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: P G
Date:
Subject: What is the default timeout setting for connections to the db?
Next
From: Raj Mathur
Date:
Subject: Re: Users and groups