PDA

View Full Version : Passwords In Postgres

monher
09-27-02, 05:43
Hello!

I have shaped the file pg_hba.conf. I have included the next line:

TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
host prueba 127.0.0.1 255.255.255.255 passwords password

and besides, I have this:
pg_passwd /usr/local/pgsql/data/passwords
to can add passwords, but I want to read the passwords of the table pg_shadow, but I canīt, because the passwords that arenīt in the file password, but they are in the table pg_shadow I canīt use to connect.

what can I do to use the passwords of the table pg_shadow?

Hope someone can help
Thanks.
MaleMan
10-11-02, 00:58
you can try md5, but im not sure which is more secure between the two.

lets ask eperich... :) eperich, can you help?

then if you access through a network, you can add some lines there allowing other computers in the specified network to access your postgreSQL server. its also one of the possible problems may occur.

:D