database error

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

database error

Postby Woifei » Thu Feb 10, 2011 1:12 pm

when i want to start PT3 a window pops up that has never poped up before - it says:

Configure PostgreSQL Database
Name: PT3_2011_02_10_180045
PostgreSQL Server Information
Database: PostgreSQL
[ ] This database already exists (i think it does ? ) Browse database
Server: localhost User: postgres
Port: 5432 Password: dbpass
Create/Connect (depends if [x] or [ ] in "databse already exists" and Cancel

When i click [x] and "Connect" it says:
"Unable to connect to PostgresSQL database:
PT3_2011_02_10_180045
Reason: Unable to login to database
(PT3_2011_02_10_180045). Reason: server closed the connection
unexpectedly This probably means the server terminated abnormally
before or while processing the request."

i recently made a database backup - can i have something to do w/ it?
Woifei
 
Posts: 5
Joined: Sat May 29, 2010 6:10 am

Re: database error

Postby kraada » Thu Feb 10, 2011 2:03 pm

Making a backup shouldn't cause that sort of error - did you install or change your anti-virus or firewall software?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: database error

Postby Woifei » Thu Feb 10, 2011 2:07 pm

no, i didn't...
Woifei
 
Posts: 5
Joined: Sat May 29, 2010 6:10 am

Re: database error

Postby kraada » Thu Feb 10, 2011 2:24 pm

Click Start, type in Event Viewer and hit enter - go to the Application logs in the top left window, do you see any errors listed for PostgreSQL there? If so, could you tell me what they say?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: database error

Postby Woifei » Thu Feb 10, 2011 2:37 pm

no, no errors or warnings
Woifei
 
Posts: 5
Joined: Sat May 29, 2010 6:10 am

Re: database error

Postby kraada » Thu Feb 10, 2011 3:00 pm

Then please attach the last 5 files in the C:\Program Files\PostgreSQL\8.3\data\pg_log directory to a support ticket and we'll gladly investigate further for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: database error

Postby Woifei » Fri Feb 11, 2011 6:43 am

i attached my last 5 files yesterday, but today PT3 works , without any troubles - i'll support my last file too then...
Woifei
 
Posts: 5
Joined: Sat May 29, 2010 6:10 am

Re: database error

Postby kraada » Fri Feb 11, 2011 9:47 am

I'm glad to hear it's working again, though! Has this happened to you before?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: database error

Postby Woifei » Fri Feb 11, 2011 10:02 am

no, that was the very first time, i have no clue why it happened, but i'm happy that it works just fine now, thx for the fast replies!
Woifei
 
Posts: 5
Joined: Sat May 29, 2010 6:10 am

Re: database error

Postby kraada » Fri Feb 11, 2011 10:14 am

No problem. If it happens again, let me know.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 16 guests

cron