Re: Invalid User ID: 0

Howard Bagcat wrote:

>Anyone,
>
>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 
catalog via:

select * from pg_user;

Then, you can check whether the user you're referring to actually exists.


Thanks!

Best Regards,

Carlo
------
Carlo Florendo
Astra Philippines Inc.
www.astra.ph



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]