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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings