Обсуждение: BUG #4581: Difficult uninstall
The following bug has been logged online: Bug reference: 4581 Logged by: Henrik Svensson Email address: henrik.svensson@mydata.se PostgreSQL version: 8.3.1 Operating system: Windows XP SP2 Description: Difficult uninstall Details: To remove PostgreSQL so you can reinstall it to my findings the following must be done: - Do "Control Panel" "Add Remove Programs" select "PostgreSQL 8.3" click "Remove". That's normal. - Delete all files (still remaining??!!) under C:\Program Files\PostgreSQL. - Remove the service-user postgres. The reinstall can't handle that this user exists (?!). - Delete all fields in the registry containing the substring postgre (???????????!!!!!!!!!!!!). I bet there is a simpler way, right?
On Mon, Dec 15, 2008 at 3:41 PM, Henrik Svensson <henrik.svensson@mydata.se> wrote: > > The following bug has been logged online: > > Bug reference: 4581 > Logged by: Henrik Svensson > Email address: henrik.svensson@mydata.se > PostgreSQL version: 8.3.1 > Operating system: Windows XP SP2 > Description: Difficult uninstall > Details: > > To remove PostgreSQL so you can reinstall it to my findings the following > must be done: > - Do "Control Panel" "Add Remove Programs" select "PostgreSQL 8.3" click > "Remove". That's normal. Yes. > - Delete all files (still remaining??!!) under C:\Program Files\PostgreSQL. They are still remaining because they are your data. You wouldn't want them to be removed when upgrading I assume? > - Remove the service-user postgres. The reinstall can't handle that this > user exists (?!). It could, but we have no way of knowing if you're using that user account for something else - for example, a different version (or distribution) of PostgreSQL. Running two in parallel is not uncommon when performing a major upgrade. Removing the user account could easily break other things quite horribly. > - Delete all fields in the registry containing the substring postgre Some keys are retained to tell any future (re)installation or minor upgrade where to find the data that was left behind. > (???????????!!!!!!!!!!!!). Your keyboard seems to be broken. Regards, Dave.
On Mon, Dec 15, 2008 at 4:40 PM, <Henrik.Svensson@mydata.se> wrote: > Thanks Dave for your quick reply. > > So, as I understand it, the registry entries are left to simplify e.g. at > reinstallation enabling skip of some steps in the wizard. > The reason I was asking, is that I tried an application I have made on a > number of persons, and that some of them forgot the password they set on > the internal user (the DBO). The only way that I could come up with, was to > reinstall PostgreSQL. > > Is there an other way? Edit the pg_hba.conf file in the data directory, and add a line to grant trusted access to the database. Then, tell the server to reload it's configuration (the pause button on the services control panel applet should do this), and login as postgres using pgAdmin or psql. Change the password to something memorable, and then put pg_hba.conf back how it was and reload the config again. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Thanks Dave for your quick reply. So, as I understand it, the registry entries are left to simplify e.g. at reinstallation enabling skip of some steps in the wizard. The reason I was asking, is that I tried an application I have made on a number of persons, and that some of them forgot the password they set on the internal user (the DBO). The only way that I could come up with, was to reinstall PostgreSQL. Is there an other way? Henrik Svensson System Software Phone +46 (0)8 475 56 87 Fax +46 (0)8 475 55 01 MYDATA automation AB Box 20155, SE-161 02 BROMMA, Sweden http://www.mydata.com Registered Office: Stockholm; Reg.no. 556238-6739 "Dave Page" <dpage@pgadmin.or g> To "Henrik Svensson" 2008-12-15 16:52 <henrik.svensson@mydata.se> cc pgsql-bugs@postgresql.org Subject Re: [BUGS] BUG #4581: Difficult uninstall On Mon, Dec 15, 2008 at 3:41 PM, Henrik Svensson <henrik.svensson@mydata.se> wrote: > > The following bug has been logged online: > > Bug reference: 4581 > Logged by: Henrik Svensson > Email address: henrik.svensson@mydata.se > PostgreSQL version: 8.3.1 > Operating system: Windows XP SP2 > Description: Difficult uninstall > Details: > > To remove PostgreSQL so you can reinstall it to my findings the following > must be done: > - Do "Control Panel" "Add Remove Programs" select "PostgreSQL 8.3" click > "Remove". That's normal. Yes. > - Delete all files (still remaining??!!) under C:\Program Files \PostgreSQL. They are still remaining because they are your data. You wouldn't want them to be removed when upgrading I assume? > - Remove the service-user postgres. The reinstall can't handle that this > user exists (?!). It could, but we have no way of knowing if you're using that user account for something else - for example, a different version (or distribution) of PostgreSQL. Running two in parallel is not uncommon when performing a major upgrade. Removing the user account could easily break other things quite horribly. > - Delete all fields in the registry containing the substring postgre Some keys are retained to tell any future (re)installation or minor upgrade where to find the data that was left behind. > (???????????!!!!!!!!!!!!). Your keyboard seems to be broken. Regards, Dave.