Thomas Bley wrote:
> I type: pg_dump -h localhost -U postgres database_name and there is no
> question for the password.
Have you created a .pgpass (or whatever the equivilant in the Windows
world is)? That could be supplying 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
I'm not sure what the default behaviour for local socket connections
is. Perhaps you should add a line to your pg_hba.conf to define a rule
for local socket connections. For example
local all all md5