Unable to create PostgreSQL database: PT3 Alpha....

[Chaser8]

I got this message when I tried to create my new pt3 db for the first time:

Unable to create PostgreSQL database: PT3 Alpha DB1
Reason: Unable to execute query: CREATE DATABASE "PT3 Alpha DB1" WITH OWNER = Chaser ENCODING = 'SQL_ASCII' TABLESPACE = pg_default;; Reason: Fatal Error (ERROR: role "chaser" does not exist )

I double-checked my postgre login details and my login and password is correct. How to fix?

[_dave_]

Login name should probably be "postgres" (with associated password). PGSQL seems to think user "Chaser" does not exist.

[Chaser8]

[quote="_dave_"]Login name should probably be "postgres"[/quote]

No, it shouldn't because I set my login name as "Chaser," and not "postgre." If I use anything else, it says user authentication failed.

I run spade eye perfectly fine with my postgre db login and password.

[Josh]

Try using "postgres" with an empty password.

[Chaser8]

[quote="Josh"]Try using "postgres" with an empty password.[/quote]

I got this message

Unable to create PostgreSQL database: PT3 Alpha DB1
Reason: Unable to login to database (template1). Reason: fe_sendauth: no password supplied

[Josh]

OKay, that's not going to work. Can you post or attach a screenshot to a support ticket of the settings for the "Chaser" login?

[holepunch]

if anyone is installing post gres on a vista machine, it has to be done with the user account setting switched off in the control panel,you can switch it back on again after installation, also pt3 has to be run as administrator

[holepunch]

sry that should be user account control

[Chaser8]

http://img204.imageshack.us/my.php?imag ... resqo6.png

This?

[_dave_]

[quote="Chaser8"xe5]http://img204.imageshack.us/my.php?image=postgresqo6.png

This?[/quotexe5]
That looks like HM...

Unless you are certain what you are doing, changing the superuser name to not "postgres" is a recepie for disaster imo.