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
postgresqlbut
>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