Re: Cannot connect to the database (PG 7.3)

Поиск
Список
Период
Сортировка
От Michiel Lange
Тема Re: Cannot connect to the database (PG 7.3)
Дата
Msg-id 5.1.0.14.0.20030127191100.00b34ba8@192.168.1.3
обсуждение исходный текст
Ответ на Re: Cannot connect to the database (PG 7.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Cannot connect to the database (PG 7.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
but, but.... it is even with the psql command...
it will differ if I put a -U parameter with postgres or 20020003
postgres, michiel or most other names will connect fine, however the user
20020003 will not...
I get that FATAL error... all users should be able to connect to the
database, according to pg_hba.conf
and when I do: SELECT * FROM pg_user; I get all users, including 20020003
returned... and 20030003 has userid 106, which is mentioned in the list
SELECT * FROM pg_group; so, the account should be set up correctly. A ALTER
USER 20020003 WITH ... has not helped either, but I am very certain the
user exists... but is not allowed to connect to the database...

But I will try to see what happens with query logging... never thought that
connecting would issue a query as well... not so strange an idea though...
I'll check it out...

Michiel

At 09:10 27-1-2003 -0500, Tom Lane wrote:
>Michiel Lange <michiel@minas.demon.nl> writes:
> > it is pretty strange... might it be a bug?
>
>I'm quite sure it's a bug in your code.  Try turning on query logging so
>you can see what queries are being issued; maybe that will help solve
>the problem.
>
>                         regards, tom lane



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Michael Cupp"
Дата:
Сообщение: New User - Please Help
Следующее
От: Jeff Boes
Дата:
Сообщение: FSM settings -- how to tell if they are working?