On Thu, Jul 18, 2013 at 3:52 PM, Arvind Singh
<arvindps@hotmail.com> wrote:
Hello and greetings,
I want to install postgresql for use as the backend to a Windows application.
This seems to be no problem if postgresql is NOT already installed on the system. which is not in this case.
postgresql is already installed and unless the command line parameters contain the superpassword etc of the existing installation , the install fails. As I will likely never know the superpassword or other account details of any pre-existing postgresql instances and the machine owners may not either.
How to then proceed and install a new instance that can be used by our application.
Window 7
Postgres 9.3 beta
The password you need to reset is at the operating system level. To do this on Windows, do the following:
1) Right click on the 'My Computer' desktop icon ( or if the icon is not on the desktop, open the start menu and right click on the 'My Computer' menu item)
2) Choose 'Manage' from the pop up menu
3) Expand the 'Local Users and Groups' folder
4) Expand the 'Users' folder
5) On the right hand side of the screen, you will see all the users defined on the system.
6) You can right click on the "postgres" user name and choose 'Set Password' and then change it to something else
OR You can delete the user and then have the installer recreate the user.
You will need to be logged into the computer as an administrative user to do the above.
Thanks & Regards
Raghu Ram