PDA

View Full Version : Optimise error



johncc
08-26-2011, 10:09 AM
help please

Sarek
08-26-2011, 02:09 PM
1) This works with Postgres 8.4 only
2) And only if it is installed by default.

johncc
08-26-2011, 02:13 PM
So you are saying the button that says optimise will only work with 8.4 and how would i or anyone else know what was installed by default

Sarek
08-26-2011, 02:17 PM
It tries to find specific file to edit it - postgresql.conf
and the only location where it tries to find it is
c:/program files...../postgresql.../data - which is default path
If data folder is in another place - "file not found"

johncc
08-26-2011, 02:20 PM
OK ty

Patvs
08-26-2011, 04:34 PM
If you're using SQL 9.0/8.3/8.2 or have 8.4 installed to a non default folder, you can perform 'maintenance' manually by running a vacuum/analyse and/or reindex in pgadminIII.

Read http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+