can't log in

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

can't log in

Postby phatus » Sat Sep 12, 2009 3:47 am

I tried to reinstall my PT3 and i must have deleted the PostgreSQL Database. I'm now asked to log in and when i try i get this message:

Unable to create PostgreSQL database: PT3 DB
Reason: Unable to execute query: CREATE DATABASE "PT3
DB" WITH TEMPLATE = template0 ENCODING =
SQL_ASCII';; Reason: Fatal Error (ERROR: database "PT3
DB" already exists )

Does anyone know how i can sort this out?

Thanks
phatus
 
Posts: 42
Joined: Wed Mar 05, 2008 7:48 pm

Re: can't log in

Postby WhiteRider » Sat Sep 12, 2009 5:10 am

Are you using Build 5.2 of PT3?
(If not, please update: Download page)

That sounds like you just lost the configuration of your existing database so PT3 is trying to create a new one for you but can't because one with the default name already exists.
I would have expected it to just create one with a different name.
What happens after you OK that message?
If you are able to run PT3, go to the Database > Database Management window and click New, then Browse Databases and select your existing database - that should fix it.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: can't log in

Postby Yogi Rob » Tue Sep 15, 2009 9:46 am

I assume you are stuck at the "Configure PostgreSQL Database" dialog at startup.

You'll probably want to use that existing database. If you do:

Check the "This database already exists" checkbox. The "Create" button will turn into the "Connect" button.

If you want to start fresh with a new database:

Change the text which follows the "Database:" area in the "PostgreSQL Server Information" and it's also a good idea to change the Name: field above that too.

- RJ
Yogi Rob
Developer
 
Posts: 1078
Joined: Tue Jul 07, 2009 9:33 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 21 guests

cron
highfalutin