[ADMIN] password administration

1998-12-17 Thread Adam Maddock
Hi All, As one who is fairly new (within the last two months) to Postgre, I've looked through the Archives for this list a bit and have seen this issue addressed a number of times, but no strong solutions posted. Has anybody devised a good/secure way of allowing users to control their own passwo

Re: [ADMIN] password administration

1998-12-17 Thread Charles Curley
I don't know about secure but what I've done is linked the pg_passwd file to /etc/passwd and then people remote ODBC user can change their database password via the passwd command (or yppasswd). I've got a RH 5.0 system running without shadowed password but with NIS. I'm curious what people think

Re: [ADMIN] password administration

1998-12-17 Thread Adam Maddock
Hmm... that doesn't work on my system because my system's logon/passwd commands use a different encryption altorhythm than Postgres. I wonder if there is a way to change one or the other's scheme. Did you have to hack anything or did it work "out-of-the-box"? My Linux kernel is 2.0.34 and my di

[ADMIN] More problems compiling PostgreSQL 6.4 on Digital Unix 4.0d

1998-12-17 Thread Carl Riches
I am still having problems compiling PostgreSQL 6.4 on Digital Unix 4.0d (DEC Alpha platform). The problems now are with the macro: S_INIT_LOCK( ) I can't figure out how this macro is supposed to work and what data type it is asking for. Here are the error messages and code snippets of inte