Hi, I have installed PostgreSQL 8.3.4 on Windows Vista Business Edition. My currently logged on user is the only user that does not need to specify a password when running psql -U postgres I used the following guide:
PostgreSQL on Windows with SSL ---------------------------------- --All variables are in CAPITALS-- Create POSTGRES_SERVICE_USER Remove POSTGRES_SERVICE_USER from Users Assign POSTGRES_SERVICE_USER_PASSWORD to POSTGRES_SERVICE_USER Grant POSTGRES_SERVICE_USER Run As Service (secpol.msc) Create PGDIR (e.g. C:\Program Files\PostgreSQL) Create PGDATA (e.g. C:\ProgramData\PostgreSQL\Data) Define PGDATA Define PGBIN (i.e. PGDIR\bin) Add PGBIN to the Path Give POSTGRES_SERVICE_USER change rights on both PGDATA as well as PGDIR Extract PostgreSQL Windows archive to PGDIR As an admin register PostgreSQL service pg_ctl.exe register -U POSTGRES_SERVICE_USER -P POSTGRES_SERVICE_USER_PASSWORD -m smart Start a shell as POSTGRES_SERVICE_USER runas /user:POSTGRES_SERVICE_USER cmd.exe Run initdb <-- PGDATA must exist and be writable initdb.exe -A md5 -U POSTGRES_SUPER_USER -W Create certificate openssl req -new -text -out server.req -newkey rsa:8192 openssl rsa -in privkey.pem -out server.key openssl req -x509 -in server.req -text -key server.key -out server.crt Edit postgresql.conf listen_addresses = 'localhost' ssl = on log_destination = 'stderr' logging_collector = on log_directory = 'pg_log' log_filename = 'postgresql-%Y-%m-%d.log' log_rotation_size = 5MB client_min_messages = log log_min_messages = info log_min_error_statement = info log_timezone = Europe/Amsterdam Edit pg_hba.conf hostssl all postgres ::1/128 md5 hostssl all postgres 127.0.0.1/32 md5 It seems odd to me that the user that is logged in (and created the services and directories) does not need to specify a password I checked ownership on all directories (they are owned by local administrators) and the specific user is nowhere specified in the security permissions Other users (also members of administrators) do need to specify a password. Even though this is only a local development installation, I would really like to understand why this happens Thanks in advance, Serge Fonville
