Page 1 of 2

Help Please with perfomance help tuning.

PostPosted: Wed Sep 23, 2009 10:55 pm
by paul rizzo
Hi I just reading the Performance Tuning PostgreSQL thread and removed my postegresql 8.3 to get 8.3x. (let me note i don't know much about computers and just want my pt3 to run better so exuse me if some of my questions sound stupid)

my problem is that when i went to download it I cant find it on their site. Maybe I could get a direct link to the download for postgresql 8.3.x

Re: Help Please with perfomance help tuning.

PostPosted: Wed Sep 23, 2009 11:25 pm
by paul rizzo
Actually want I need to know is which one to download.

Re: Help Please with perfomance help tuning.

PostPosted: Thu Sep 24, 2009 5:53 am
by WhiteRider
I would suggest getting the PGInstaller version of the latest 8.3, which is currently 8.3.8.
http://www.postgresql.org/ftp/binary/v8.3.8/

Re: Help Please with perfomance help tuning.

PostPosted: Thu Sep 24, 2009 8:44 pm
by paul rizzo
Thanks for getting back to me. But before i read it I found a download for 8.4 from a link from postgreSQL website to a site www.enterprisedb.com and I downloaded it their. Should I erase the one I just got and install through the link you just gave me?

Also, after the downloaded i realized that postgres gave me a user account in that name. Is that because I didn't disable the user account control?

Re: Help Please with perfomance help tuning.

PostPosted: Fri Sep 25, 2009 3:56 am
by WhiteRider
8.4 is fine, and the enterprise DB installer is OK too, but once you've installed that way you need to continue installing that way in future.

The 'postgres' user will always be created - this is needed.

Re: Help Please with perfomance help tuning.

PostPosted: Sat Sep 26, 2009 12:37 am
by paul rizzo
Thanks for the reply, What do i have to do to get the PT3 connected to postgres? Right now when i go pt3 it says it isn't connected to postgres

Re: Help Please with perfomance help tuning.

PostPosted: Sat Sep 26, 2009 6:44 am
by WhiteRider
Do you have the postgres service running?
Start > Programs > Postgres > Start Service.
Do you see any postgres.exe processes in Task Manager > Processes?

Re: Help Please with perfomance help tuning.

PostPosted: Sat Sep 26, 2009 2:23 pm
by paul rizzo
Yeah, the postgres service is running. I went to task manager under processes and I found six postgres.exe processes. Also I stopped service and started again and six came back.

Re: Help Please with perfomance help tuning.

PostPosted: Sat Sep 26, 2009 3:05 pm
by paul rizzo
paul rizzo wrote:Yeah, the postgres service is running. I went to task manager under processes and I found six postgres.exe processes. Also I stopped service and started again and six came back.



Also, let me say I know nothing about computers. I don't know if i have it set up correctly at all. When i downloaded 8.4 i selected the win32 like directed but im not sure that i selected the zip folder. I don't remember extracting the file, selecting a language or anything.

Is it bad to uninstall/reinstall more than absolutely necessary, because at this point I would feel better just dumping this 8.4 and installing it again (and following the instructions better)

Thanks again for you time.

Re: Help Please with perfomance help tuning.

PostPosted: Sun Sep 27, 2009 7:01 am
by WhiteRider
Did you fully uninstall postgres before re-installing, and install with the defaults?
As long as there is only one postgres service running PT3 should connect to it.

Do you have any existing databases that you need to keep?

highfalutin