From: | Thomas Bley <thbley(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | password is no required, authentication is overridden |
Date: | 2006-07-17 19:31:45 |
Message-ID: | 44BBE5A1.2000508@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I already tried to mail security(at)postgresql(dot)org but my message was stalled.
Version: 8.1.4 (binary for win32)
OS: Windows XP SP2
I type: pg_dump -h localhost -U postgres database_name and there is no
question for the password.
I haven't made changes to pg_hba.conf. I'm logged in as user "admin",
not "postgres", the password is not empty.
my pg_hba.conf:
# ...
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
without the -h localhost, I get the same (complete) dump
SHOW hba_file;
gives me:
d:/program files/postgreSQL/8.1/data/pg_hba.conf
(I only have one file named pg_hba.conf on my computer.
I tried again with "pg_dump -U postgres -W database_name" when I enter
the right password it passes, with the wrong one it denies me, without
the "-W" it lets me pass.
thanks and bye,
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2006-07-17 19:36:08 | Re: TODO: Mark change-on-restart-only values in postgresql.conf |
Previous Message | Zdenek Kotala | 2006-07-17 19:28:21 | TODO: Mark change-on-restart-only values in postgresql.conf |