Hosting Provided By

Re: [GENERAL] default superuser

From: Joshua D. Drake <jd(at)commandprompt.com>
Date: Fri Dec 28 2007 - 13:07:05 EST

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 28 Dec 2007 12:59:28 -0500
"Gauthier, Dave" <dave.gauthier@intel.com> 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)

Do you need help?

iD8DBQFHdTtMATb/zqfZUUQRAjFuAJ9T0xM7K4vAbrtqw3ZzFW8BVngZzQCfUgZH /mG3+TfqT/8eK1MGwkU4E4E=
=pZgy
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Fri Dec 28 13:05:53 2007

This message: [ Message body ]
Next message: Robert Treat: "Re: [TLM] Re: [GENERAL] How to insert on duplicate key?"
Previous message: Gauthier, Dave: "Re: [GENERAL] default superuser"
In reply to: Gauthier, Dave: "Re: [GENERAL] default superuser"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 23:00:36 EDT