On Fri, 30 Apr 1999 14:23:58 -0400, Michael Konrad
<mkonrad@blue.syr.edu> wrote:
>I have installed PostgreSQL 6.3.2 on RedHat Linux 5.2 by rpm. When I try
>to connect to template1 I get the follow error message:
>Connection to database 'template1' failed.
>Fatal 1: SetUserID: user "mkonrad" is not in "pg_shadow".
>
>I have tried to add myself "createuser" under root and I get the
>following message:
>Connection to database 'template1' failed.
>Fatal1: SetUserID: user "root" is not in "pg_shadow"
>createuser: database access failed.
>
>It is a stock install and I have no idea how the postgres user is set up
>nor can I seem to give myself access when I'm logged in as root.
>
>Help?
>
>Thanks,
>Michael
>
>
1. As root change the password for user postgres.
-- passwd postgres
2. Log in as user postgres and make yourself a user
-- createuser yourname
