# TYPE DATABASEUSERADDRESSMETHODlocalallallmd5 peermeans it will trust the identity (authenticity) of UNIX user. So not asking for a password. md5means it will always ask for a password, and validate it after hashing withMD5. You can, of course, also create more specific rules for a spec...
, and you're running Ubuntu, psql should be connecting via a Unix-domain socket, so PostgreSQL probably isn't configured to allow one of the password authentication methods for the postgres user. You can test this by running: sudo -u postgres psql If the above works, your server is ...
>>for the password. >> >>[/color] > >Look in the manpage for psql, there are several ways to stop it asking for >passwords, including the PGPASS environment variable, tne .pgpass file and >setting the user as trust in the config. > >Any of these will do what you want... > >...