Howard Bagcat wrote:
>I am troubled on logging on to my postgresql running under Cygwin. Postmaster says, "Fatal: Invalid User ID 0" after connecting. I
>know for sure that the username that I am using to log is existing. Thinking that having a new user will solve the problem, I
>tried creating a new user but same error was displayed. I tried working on psql in the hope that I can connect to postgresql but
>the same has occured.
Please give the details of the exact command you're running.
In any case, you might try to connect as user postgres.
psql -d template1 -U postgres
If you're able to connect to the psql shell, try checking the users
select * from pg_user;
Then, you can check whether the user you're referring to actually exists.
Astra Philippines Inc.
In response to
pgsql-cygwin by date
|Next:||From: Daron||Date: 2004-07-26 15:06:45|
|Previous:||From: mike g||Date: 2004-07-26 02:32:09|
|Subject: Re: initdb failing !|