-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sunday 07 March 2004 16:51, Oliver Elphick wrote: > On Sun, 2004-03-07 at 17:59, Michael Satterwhite wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On a new Debian install with postgresql, I'm trying to add a user. The > > master user (postgres) shouldn't have a default password, so I'd expect > > the command > > > > createuser -U postgres -a username > > > > to work. I'm getting an IDENT failure on postgres, however. I *KNOW* I've > > done this on an initial install under a different distro before ... but > > that doesn't mean that it was the correct way, of course. It's also > > possible that I've got a bad case of tunnel vision. > > > > Would someone be so kind as to point out what I'm missing? > > You need to be logged on as postgres as well: > > $ su > # su - postgres > $ createuser -U postgres -a username > ... > $ exit > # exit > $ > > The default authentication setup is "ident sameuser" in > /etc/postgresql/pg_hba.conf, which means that you can only be the > PostgreSQL user whose name matches your login identity.
Thanks much. Appreciate the help. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAS6uQjeziQOokQnARAsRWAJ0cO+VvtBi/9/YlZsW6xbXSXJ1JLwCfeUYe ivP3QU2kHvoRiHraKVOqykk= =2m/q -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
