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

[Chaser8]

And i've tried CHASER, Chaser, chaser, POSTGRES and postgres as logins both with and without a password.
Nothing worked.

[Josh]

Okay, I think I have fixed this. Unfortunately it didn't make it into this new beta, but it will be in the next. Thanks for your patience and your help in figuring this out.

[Chaser8]

So the problem is on PT3's end and not mine? I thought for sure that it was something wrong with my database that caused this..

[Josh]

I'm pretty sure it was on our end, with the way we were creating the databases.

[Chaser8]

Hey boys, I have the same problem with beta 3

Here's the msg when I try to create a new db:

Unable to create PostgreSQL database: PT3 Beta DB1 Reason: Unable to execute query: CREATE DATABASE "PT3 Beta DB1" WITH TEMPLATE= template0 ENCODING = "SQL_ASCII"; ALTER DATABASE "PT3 Beta DB1" OWNER TO Chaser;; Reason: Fatal Error (ERROR; role "chaser" does not exist)

Here's a portion of the backup file from postgre admin

CREATE DATABASE "CHASER" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';


ALTER DATABASE "CHASER" OWNER TO "Chaser";

\connect "CHASER"

SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1733 (class 0 OID 0)
-- Dependencies: 4
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: Chaser
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- TOC entry 301 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: Chaser
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1307 (class 1259 OID 16409)
-- Dependencies: 4
-- Name: blind_structure; Type: TABLE; Schema: public; Owner: Chaser; Tablespace:
--

[APerfect10]

Go Start->Run, "cmd" -> OK.

Run:
[code8kk]net user Chaser[/code8kk]

What is returned?

Best regards,

Derek

[Chaser8]

User name Chaser
Full Name Chaser
Comment PostgreSQL service account
User's comment
Country code 000 (System Default)
Account active Yes
Account expires Never

Password last set 1/16/2008 3:53 PM
Password expires Never
Password changeable 1/16/2008 3:53 PM
Password required Yes
User may change password No

Workstations allowed All
Logon script
User profile
Home directory
Last logon 1/31/2008 5:40 PM

Logon hours allowed All

Local Group Memberships
Global Group memberships *None
The command completed successfully.

[APerfect10]

That was silly of me. Your error is with the database user not the service user. Sorry

Are you sure that when you installed PostgreSQL that you set the postgres username to "Chaser" and not just the service account? It appears there is no user by the name of "Chaser" in your PostgreSQL database. We can create the user now; however, you will need to know the username and password that you initially supplied (although we could force PostgreSQL to not need the password)

Best regards,

Derek

[Chaser8]

I'm pretty sure Chaser is what I used, but now that I'm getting error messages all over place, I'm not so sure. I have no idea what other name I could have used though, and I installed postgreSQL very recently.

How do I look up my username? How do I change it?

Can I uninstall postgreSQL and reinstall it with a fresh set of username/password? How will reinstalling postgreSQL affect my current PT2 database?

[Chaser8]

Here's a shot of my pgAdminIII

http://img201.imageshack.us/my.php?imag ... hotns5.jpg