Re: users

On Fri, Sep 22, 2000 at 10:36:53PM +0000, Chris wrote:
> Greetings,
>
> When ever a normal user (anyaccount besides "postgres") tries to
> run psql they get the following message:
>
> Connection to database 'dank' failed.
> FATAL 1: SetUserId: user "chrisp" is not in "pg_shadow"

You probably have not added any users to the database. For more info,
check out:

http://www.postgresql.org/docs/user/app-createuser.htm

You may also want to create a database for each user to access. For more
info on that, see this page:

http://www.postgresql.org/docs/user/app-createdb.htm

Finally, now is probably a good time to secure Postgres by setting up
pg_hba.conf . It's documented here:

http://www.postgresql.org/docs/admin/client-authentication.htm

HTH,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Blaming guns for Columbine is like blaming spoons for Rosie O'Donnell
being fat.