From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Floyd Shackelford <floyds(at)4peakstech(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: can't get user authentication to work - HELP! |
Date: | 2000-11-23 16:31:26 |
Message-ID: | Pine.LNX.4.21.0011231729400.1355-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Floyd Shackelford writes:
> i created a user using createuser named "user1" with password "password1"
> my pg_hba.conf file has the following entry:
> host all 192.168.1.0 255.255.255.0 password pg_passwd
> i try the following:
> psql -h 192.168.1.200 -d a_database -U user1 -W
> and i enter "password1" (sans quotes) at the password prompt and get:
> psql: FATAL 1: SetUserId: user 'user1' is not in 'pg_shadow'
>
> How do I get this to work? How do i get an entry into pg_shadow?
Normally you get one with createuser. Perhaps you have two different
postmasters running and the createuser command picked the wrong one?
> psql -h 192.168.1.200 -d a_database -U postgres -W
> and I get:
> psql: Password authentication failed for user 'postgres'
By default the postgres user doesn't have a password. You need to give it
one first. (See ALTER USER.)
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
From | Date | Subject | |
---|---|---|---|
Next Message | bmccoy | 2000-11-23 16:36:18 | Re: Running several postmaster using same database in parallel |
Previous Message | Tom Lane | 2000-11-23 16:29:47 | Re: Running several postmaster using same database in parallel |