by TBenBaker » Thu May 01, 2008 10:34 pm
I downloaded and installed PostgreSQL v 8.2.6-2. I selected convert database from the Utilities menu and went to settings, my port is 5432 , server is localhost, username postgres and ODBC was default and encoding UNICODE (although I tried both). When I selected my database and clicked start conversion it very briefly showed the progress bar and then gave me an error message that said something about localhost and TCP/IP and suggested either my password/username was wrong or there was something wrong with te ODBC or there was a third option. I did not know what to do but thought my password might have been too long (15 characters) since it more than filled the allowed space, so I tried to uninstall postgreSQL and start again but when asked to initialize database cluster it gave me an error message because there was data already there or something. It said I either I didn't need to initialize it or needed to create a new database or something, I tried to continue without initializing and ended up with an error at the same stage at before. I tried fudging with the PostgreSQL setting and now when I try to select and ODBC entry to use it is blank. I imagine the best way to proceed would be to somehow erase everything I have done and start over but I can't even figure out how to do that. Suggestions?