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@home.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.