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
