PDA

View Full Version : Postgre troubles



wykeekee
01-22-2011, 06:41 PM
I am having trouble finding this step and I just updated to PostegreSQL V9
I have 32Bit Vista

PostgreSQL:

-7 Edit your PosgreSQL.conf file in the SQL 8.x/data folder.
Do not use the Tuning Wizard. On some systems it will make changes to the postgresql.conf it shouldn't, resulting in being unable to connect to the database!
If you experience this problem--> simply go to the 8.4/data folder, undo the changes you made and reboot.
Recommended changes:
shared_buffers = MB (set this to 20% of your system memory, but not more than 1000 MB.... round it off to 128 MB, 256 MB, 512 MB or 768 MB)
effective_cache_size = MB (set this to 2x the size of the shared_buffers)

Patvs
01-22-2011, 09:10 PM
PostgreSQL/9.0/data/postgresql.conf file--> edit the following



# - Memory -

shared_buffers = 512MB



#effective_cache_size = 1024MB