Thread: pg_passwd file missing
Hi, I've just sturted using postgresql 8 and I faced the following problem: I want to use the "password" method for the user authentication. In previous release, I linked the password_file to the dbms through the pg_passwd command, placed in the POSGTRES_HOME/bin directory. Though the "password" method is still available (see pg_hba.conf file), the pg_asswd command does not longer appear. Could anyone help me? Thanks Lorenza -- ----------------------------------------------------- Lorenza Ferrario Microsystems Division ITC-irst Via Sommarive, 18 Povo (Trento) - Italy email: ferrario@itc.it - telephone: +39 0461 314463 -----------------------------------------------------
Lorenza Ferrario wrote: > Hi, > > I've just sturted using postgresql 8 and I faced the following > problem: I want to use the "password" method for the user > authentication. In previous release, I linked the password_file to the > dbms through the pg_passwd command, placed in the POSGTRES_HOME/bin > directory. > > Though the "password" method is still available (see pg_hba.conf > file), the pg_asswd command does not longer appear. We removed the ability to use an /etc/passwd file in PostgreSQL. We now encourage using MD5 because we can prevent sniffing the password over the wire because we random-salt the value. We do have the new ability to reference a file with names in it using '@'. -- 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