can't connect to database

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 connect to database

Postby Justus » Mon Jun 28, 2010 3:03 pm

Hi,

I'm using PT3 since 2 years.

Now the following happens: when i'm starting PT i can't connect to a database.
"Error conecting to default database."

It's not possible to choose a database, when i try to create a new one the following appears:
"Unable to create PostGreSQL database ...
Unable to login to database (template1)
Reason: Server closed the connection unexpectedly...

In the right corner it shows : PostgreQL v0.0.0

Any ideas how to start it again?

Andi
Justus
 
Posts: 8
Joined: Mon May 26, 2008 5:27 pm

Re: can't connect to database

Postby kraada » Mon Jun 28, 2010 4:45 pm

That tends to mean PostgreSQL has been uninstalled - do you still have PostgreSQL installed on your system?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: can't connect to database

Postby Justus » Mon Jun 28, 2010 5:02 pm

yes, PostgreSQL 8.3 is installed.

My PC crushed a few weeks ago, i'm using a new mainboard and a new HDD now, but we could recover and transfer the dates and PT3 was running as before. The databases could be used. Since a few days i'm receiving this message.
Justus
 
Posts: 8
Joined: Mon May 26, 2008 5:27 pm

Re: can't connect to database

Postby kraada » Mon Jun 28, 2010 5:34 pm

Try uninstalling PostgreSQL and then reinstalling it per the guide on our documentation page, it sounds like the likely cause is the PostgreSQL installation not functioning properly.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: can't connect to database

Postby Justus » Mon Jun 28, 2010 6:23 pm

hi, i`ve tried to uninstall and then reinstall it. Using Win XP.

when i'm trying to intialize a databasecluster (page 19)

following fault appears:
the chosen directory isn't empty. (hope i translated it correctly, I'm from germany)

So i cannot install it this way... :?

don't know what to do now. :cry:
Justus
 
Posts: 8
Joined: Mon May 26, 2008 5:27 pm

Re: can't connect to database

Postby kraada » Mon Jun 28, 2010 7:07 pm

Uncheck "Initialize Database Cluster" and then the installation will complete and use your old data directory.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: can't connect to database

Postby Justus » Tue Jun 29, 2010 4:44 am

Sorry, my fault :oops: that i haven't seen the hint in the installation guide.

Installation finished and i can open PT3 now without errors.
Have to play a few hands the next time to test if everything is fine again.

Thanks for your help, kraada
Justus
 
Posts: 8
Joined: Mon May 26, 2008 5:27 pm

Re: can't connect to database

Postby kraada » Tue Jun 29, 2010 8:54 am

You're welcome :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 25 guests

cron
highfalutin