PDA

View Full Version : cant connect to database after tuning wizard



mmiller101
07-27-2009, 05:59 AM
So i'm getting lag and am trying the tuning wizard on version 8.3 but after i try to restart it won't let me connect. Any ideas?

netsrak
07-27-2009, 06:36 AM
Is your postgresql service running?
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Patvs
07-27-2009, 09:22 AM
I have the same problem. It can be solved by restoring the original postgresql.conf (in the postgresql/data folder) and rebooting.

Apparently the Tuning Wizard makes a change it shouldn't.
I'm running PostgreSQL 8.4 on Windows 7. (new computer 6 GB RAM)

These are the changes the Tuning Wizard makes: (server utilization: MIXED)


shared_buffers = 165628 (original value 32MB)
work_mem = 33137 (original value 1MB)
maintenance_work_mem = 262144 (original value 16MB)
wal_buffers = 256 (original value 64kb)
checkpoint_segments = 64 (original value 3)
effective_cache_size = 171994 (original value 128MB)

autovacuum = true (original value ON)
autovacuum_vacuum_threshold = 1000 (original value 50)
autovacuum_analyze_threshold = 250 (original value 50)


The Tuning Wizard seems to pick more realistic numbers when I choose (server utilization: Development)
For example shared_buffers = 1024, work_mem = 1024. (but I doubt maintenance_work_mem = 16384, effective_cache_size = 167787 are right... can those values be that high??)

Here are some links of what the values should be, if you were to all change them manually:

http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html

mmiller101
07-27-2009, 01:43 PM
My service is running fine up until i do the tuning wizard and restart the program. It will not let me connect for some reason.