Thread: Auth users and command pg_passwd

Auth users and command pg_passwd

From
TooManySecrets
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi.

One year ago, I was worked with postgresql 7.1. In this, my pg_hba.conf was
"finished-line" like this; password <path/to/file_passwords>

Then, when I have one year whitout "touch" anything about postgres, I have
compiled postgresql, but I do not find the command "pg_passwd" to create a
file of passwords with same ciphered(coded).
Where the command is "pg_passwd" in the version 7.2.3? Already it does not
exist? With what command it has been replaced? I do not manage to find
nothing of this in the documentation.

I will apologize about my bad english... Sorry.

Thank you very much!!

- --
Have a nice day ;-)
TooManySecrets
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQE+S8mzICNFwaoqbY8RArUVAJ0UbUWL44hEkUlIUOOhDn2KSM9VVwCeIfPd
GSgZqtjYhdbwWpx7EDeSLas=
=HSP8
-----END PGP SIGNATURE-----


Re: Auth users and command pg_passwd

From
Bruce Momjian
Date:
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?

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

TooManySecrets wrote:
[ PGP not available, raw data follows ]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi.
>
> One year ago, I was worked with postgresql 7.1. In this, my pg_hba.conf was
> "finished-line" like this; password <path/to/file_passwords>
>
> Then, when I have one year whitout "touch" anything about postgres, I have
> compiled postgresql, but I do not find the command "pg_passwd" to create a
> file of passwords with same ciphered(coded).
> Where the command is "pg_passwd" in the version 7.2.3? Already it does not
> exist? With what command it has been replaced? I do not manage to find
> nothing of this in the documentation.
>
> I will apologize about my bad english... Sorry.
>
> Thank you very much!!
>
> - --
> Have a nice day ;-)
> TooManySecrets
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (FreeBSD)
>
> iD8DBQE+S8mzICNFwaoqbY8RArUVAJ0UbUWL44hEkUlIUOOhDn2KSM9VVwCeIfPd
> GSgZqtjYhdbwWpx7EDeSLas=
> =HSP8
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.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

Re: Auth users and command pg_passwd

From
TooManySecrets
Date:
-----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-----


Re: Auth users and command pg_passwd

From
Bruce Momjian
Date:
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