>> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
>> is not in 'pg_shadow'
Some kind of syntactic confusion at the client end, evidently: the
software is taking "password=" as your username, which I'm pretty
sure is not what you intended.
reg
Anatole Varin wrote:
>
> Hi,
> Thanks for your advice. I set my password as you advised below, however I'm
> still having some problems connecting. When I try to connect I get the
> following error message:
>
> Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
> is not
Hi,
Thanks for your advice. I set my password as you advised below, however I'm
still having some problems connecting. When I try to connect I get the
following error message:
Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'password='
is not in 'pg_shadow'
When connecting I'm u
Hi,
You could use the following...;-)
psql -U postgres template1
UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres';
You could also use GRANT or create other users as well... kindly check
the administrative section of your documentation...;-)
Cheers,
John Clark
