Page 1 of 5

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

PostPosted: Thu Jan 24, 2008 8:08 pm
by 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?

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

PostPosted: Thu Jan 24, 2008 8:21 pm
by _dave_
Login name should probably be "postgres" (with associated password). PGSQL seems to think user "Chaser" does not exist.

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

PostPosted: Thu Jan 24, 2008 8:27 pm
by 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.

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

PostPosted: Thu Jan 24, 2008 8:34 pm
by Josh
Try using "postgres" with an empty password.

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

PostPosted: Thu Jan 24, 2008 8:41 pm
by 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

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

PostPosted: Thu Jan 24, 2008 8:43 pm
by 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?

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

PostPosted: Thu Jan 24, 2008 10:13 pm
by 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

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

PostPosted: Thu Jan 24, 2008 10:14 pm
by holepunch
sry that should be user account control

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

PostPosted: Fri Jan 25, 2008 3:49 am
by Chaser8

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

PostPosted: Fri Jan 25, 2008 3:53 am
by _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.