PSQL trouble

[redicerap]

Hi, I read somewhere that I should use the newest PSQL version, downloaded 9.1.5 and installed and gave it the default port 5433, since 5432 was already used by 8.3. Then PT4 couldnt access PSQL and I got the following message:

"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 5433?"

Uninstalled both 9.1.5 and 8.3 and installed 8.4. Still the same problem. I think the DB is still there but PT4 tries to connect to 5433 instead of 5432, but im not sure. So, is my DB lost or do you have a solution for this?

[kraada]

We don't support PostgreSQL 9.1 - 9.1 has known crashing and data corruption issues. The most recent version we support is 9.0.

But regardless we should be able to help you get things set up and working again. One question first though: did you do any manual deleting after you uninstalled things the first time around?

[redicerap]

no i cant remember deleting any files. i obv want the best performance possible when playing or analyzing the DB. so, my old DB is still listed there but i cant activate it because it says it's invalid. if i cant use my old DB in a new version of PSQL id like to just delete every DB on my hard drive, download the latest supported version of PSQL and import all my (backed up) hands in the new version of PSQL. so i read somewhere that it's not possible to use the old db without backing it up and reimporting it again. if thats true then id just like to delete all DBs outside of PT4, since it hasnt access to the old db.

[kraada]

Ok, in that case uninstall PostgreSQL as you have it now and delete the C:\Program Files (x86)\PostgreSQL\ directory entirely. Do you have a 64 bit machine? If so I'll give you the link for 9.0-x64 if not I'll give you the link for 9.0-x32 and installing that to port 5432 should solve your problems here.

[Cashmandt]

I have the same problem here, what can i do?????
yesterday it works, today same message:

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 5433?"

[kraada]

Click Start type services.msc and click on it when it appears. Do you see PostgreSQL in the services list? If so, can you start it?

[Cashmandt]

Hi!
Do you mean this one? sorry its in german...it seams its not possible to start it...?!?

[Cashmandt]

HA! i think i have it! i deleted the postmaster.pid and now it looks like it works, iam now updating the database.....wait and see... ;)

and it works! :ugeek:

[redicerap]

sick i idiot just deleted everything........whatever gonna take one night to import all so its not a disaster.

[kraada]

Just deleting that one file shouldn't nuke your entire database - just don't delete more than that file . . . . otherwise . . .