-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 28 Dec 2007 12:59:28 -0500 "Gauthier, Dave" <dave.gauthier@xxxxxxxxx> wrote: > And I can connect using the "foo" user (psql -U foo mypgdb). But it > doesn't seem to require the password. Would you know why? I would > like to use the password protection. The problem is that you don't have your authentication configured. That is discussed in detail here: http://www.postgresql.org/docs/8.2/static/client-authentication.html Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHdTtMATb/zqfZUUQRAjFuAJ9T0xM7K4vAbrtqw3ZzFW8BVngZzQCfUgZH /mG3+TfqT/8eK1MGwkU4E4E= =pZgy -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster