Im upgrading from postgres 8.2 to 8.3 i backed up my database, i uninstalled postgres 8.2 im installing postgres 8.3
my question is, do i check the box to initialize database cluster when instialling?
i have tried it by not initializing the cluster, and renaming the postgres folder 8.2 to 8.3 then trying to restore the backed up database but this did not work as i couldnt get the service to run at all
i uninstalled postgres and tried reinstalling it with *initialize database cluster option but im getting an error
"The Secondary Logon service is not running. This service is required for installer to initialize cluster. Please start this service and try again"
what do i do?
i found some instructions on the internet
FAQ 9: “Secondary Logon service is not running”
Description: When installing the PostgreSQL service the above message is displayed and the installation will not continue.
Solution: The probable cause is the Windows’ Secondary Logon service is not running properly. Check the service status using
Control Panel>Administrative Tools>Services. Find the “Secondary Logon” service in the list and check the
“Status” column. It should be displaying “Started”. If not, try the following to start the service:
1. Right mouse click on the PostgreSQL server service entry and select “Properties”.
2. Change the “Start Up type” to automatic.
3. Select “Start” button. After the service starts, retry the installation.
i followed them, will let you guys know how things went after i try to reinstall