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 using username "postgres" and the password that I used
when I updated the pg_shadow file as suggested. Any ideas???
> Hi,
>
>
> You could use the following...;-)
>
>
> psql -U postgres template1
>
> UPDATE pg_shadow SET passwd='whatever' WHERE usename='postgres';
>