Обсуждение: RedHat 5.2 & PostgreSQL 6.3.2

Поиск
Список
Период
Сортировка

RedHat 5.2 & PostgreSQL 6.3.2

От
Michael Konrad
Дата:
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




Re: RedHat 5.2 & PostgreSQL 6.3.2

От
mthomp@intertrek.com (Mike Thompson)
Дата:
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