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+
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.