PC crashed reinstall Postgres

[roasted888]

Hi guys,

I/m encountering lots of troubles since i reinstalled PT and psql. databse is slow, and update cache takes more then 19 hours (i admt i quited when i saw 19 hours and running)

Can it be so that my psq 4.xx - installed by accident- causes all this trouble. I had 3.xx before...

Anyways, what is the best and easiest work around from here ? I am no wizz / expert so playing around in my registery is something i rather avoid.

Complete unistall / install pt and SQL again ?

I cant wait to get this going again :)
Thanks,\
Edwin.

[WhiteRider]

Do you mean PostgreSQL 8.4?

We've found a setting in PostgreSQL 8.4 which should speed up the slow queries.
Please try this:

Edit the postgresql.conf file (Start > Programs > PostgreSQL 8.4 > Configuration Files > postgresql.conf) - if you're using Vista or Win 7 then right click > Run As Administrator in order to be able to save the file.

On Mac the files are in /Library/PostgreSQL/8.4/data (note: not ~/library) and you can edit them with any text editor. If you don't have permission see this page.
Mac Files and Folders

Find "from_collapse_limit" and "join_collapse_limit" and set them both to 12. You must REMOVE the # from the start of the lines, like this:
from_collapse_limit = 12
join_collapse_limit = 12

Save the file and then Start > Programs > PostgreSQL > Reload Configuration (on Mac: Applications > PostgreSQL 8.4 > Restart Server).

That should help performance.

[roasted888]

Hi Whiterider,
Indeed it's 8.4.

Thanks for the info, it is however something usefull fo the future. At this vey moment im struggeling with the "error to connect to default database"

I have tried to change the config file pg_hba.conf according to the manual somewhere else on the forum -Unfortunate without result:(

BTW i have PT3 version 3.07.1 beta running on win XP

What to do, next step ?

Best,
Edwin.

[kraada]

Is PostgreSQL currently running? Click Start --> Run, type services.msc and hit enter. Locate the postgres service and attempt to start it - does it start?

[roasted888]

Hello Kraada,

followed your instruction, and the status is "blanc" when i do start it an error appears telling me postgres started but stopped, this happens when ...."

Weird msg, never seen before.
What would you suggest ?

Best, Edwin.

[kraada]

Click Start --> Control Panel --> Administrative Tools --> Event Viewer. There should be errors under the Applications section relating to PostgreSQL - please tell me what those errors say.

[roasted888]

Hi kraada,

Thanks for the spot on rply.
I've checked event viewer the next errors are displayed:
Failed to query jobs table!
2010-06-24 17:56:00 CESTFATAL: could not create any TCP/IP sockets


And the next warnings are displayed:
2010-06-24 17:56:00 CESTWARNING: could not create listen socket for "*"

Hopefully you can make something out of this, i know i don't :)

Thanks,
Edwin.

[kraada]

What version of Windows are you using?

[roasted888]

Im using windows XP Service pack 3

[kraada]

Try running this winsock fix and then rebooting your computer; that may help.