'configure postgreSQL databse' ???

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

'configure postgreSQL databse' ???

Postby Gooner933 » Sun Jul 03, 2011 12:57 pm

I have been using pt3 on a regular basis for the past couple of years. However, recently I ran into some problems with my p.c. I have now had it fixed but am unable to get onto PT3. When I double-click it, I get a window saying 'configure postgreSQL database' with a 'name' and 'postgreSQL server information' sections.

When I try to create a database:
Unable to create PostgreSQL database: PT3_2011_07_03_173227
Reason: Unable to login to database (template1). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432?

When I click 'this database already exists' and connect:
Unable to connect to PostgreSQL database: PT3_2011_07_03_173227
Reason: Unable to login to database (PT3_2011_07_03_173227). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432?

I don't know what to do. I obviously already have a vast pt3 database which I need to access before being able to continue playing.

I am unsure if the problem is a result of my p.c troubles (which involved changing ram + swapping battery + changing power supply) or if this has something to do with my trying unsuccessfully to upgrade postgresql just before my p.c crashed.

Thanks for your help,
Gooner933
 
Posts: 54
Joined: Fri Jun 12, 2009 11:53 am

Re: 'configure postgreSQL databse' ???

Postby kraada » Sun Jul 03, 2011 3:17 pm

That error is implying that PostgreSQL is not running. Could you please check to see if it's installed on your system?
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 'configure postgreSQL databse' ???

Postby Gooner933 » Mon Jul 04, 2011 5:34 am

Yeah it is installed (8.3).
Gooner933
 
Posts: 54
Joined: Fri Jun 12, 2009 11:53 am

Re: 'configure postgreSQL databse' ???

Postby WhiteRider » Mon Jul 04, 2011 9:13 am

Does it start if you go to Services (click Start, on XP click Run, and type "services.msc") and try to start the PostgreSQL service?
Do you see any PostgreSQL errors in the Event Viewer? (Start, type "event")
WhiteRider
Moderator
 
Posts: 53618
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 'configure postgreSQL databse' ???

Postby Gooner933 » Mon Jul 04, 2011 9:26 am

Thanks for your help,

Indeed when I went into Services (click Start, on XP click Run, and type "services.msc") and tried to start the PostgreSQL service, for some reason it was listed as disabled. Changed it to automatic and clicked 'start' and its all working again.

thanks
Gooner933
 
Posts: 54
Joined: Fri Jun 12, 2009 11:53 am

Re: 'configure postgreSQL databse' ???

Postby WhiteRider » Mon Jul 04, 2011 12:01 pm

Great - thanks for letting me know.
WhiteRider
Moderator
 
Posts: 53618
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 'configure postgreSQL databse' ???

Postby cuffs214 » Thu Jul 14, 2011 7:38 pm

i am havingthe same problem however mine is on automatic and when I tried to start I got an error message that windows could not start on local computer error 1053 the service did not respond to the start or control request in a timely fashion. What do I do?
cuffs214
 
Posts: 8
Joined: Thu Jul 07, 2011 10:57 am

Re: 'configure postgreSQL databse' ???

Postby WhiteRider » Fri Jul 15, 2011 4:32 am

Check our Firewall Guide to make sure your firewall isn't interfering.
If it still happens check the Event Viewer (click Start and type "event", or find it via Control Panel on XP) for errors related to PostgreSQL and post the error here or attach a screenshot to a Support ticket.
WhiteRider
Moderator
 
Posts: 53618
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 'configure postgreSQL databse' ???

Postby Tomann21 » Sun Jul 17, 2011 2:48 pm

Hi, I have the same problem, I red this comments and solutions but I can´t understand, where can I find the "Services" as Gooner wrote:

"Thanks for your help,

Indeed when I went into Services (click Start, on XP click Run, and type "services.msc") and tried to start the PostgreSQL service, for some reason it was listed as disabled. Changed it to automatic and clicked 'start' and its all working again."

I would like to repair it this way as gooner wrote, but I dont know where to find "services" or where to click to "run" etc.

Thanks for advice.
Tomann21
 
Posts: 10
Joined: Sun Jul 17, 2011 2:24 pm

Re: 'configure postgreSQL databse' ???

Postby kraada » Sun Jul 17, 2011 3:27 pm

If you're running Windows Vista or newer, just click the windows icon at the bottom left of the screen and type Services, then click on what appears. The rest of the directions will be identical.
kraada
Moderator
 
Posts: 54435
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 3 guests

cron
highfalutin