Home | Techie Talk | Story Time | About | Contact

Friday, May 01, 2009

How to run PostgreSQL under an administrator account in windows?

Earlier PostgreSQL will not run under any administrator account in Windows computer for some security reasons. However after 8.2 release it is possible to start the database under any administrator account as follows:

1. Open a command prompt and go to PostgreSQL_Home\Bin folder.

2. Execute the below command to initialize the database
initdb.exe -D PostgreSQL_Home\data

3. Execute the below command to start the database server
"pg_ctl.exe" start -D " PostgreSQL_Home\data"

Now the PostgreSQL server will start, even when the currently logged in user is an adminsitrator.

However now I am seeing nearly five instances of Postgress.exe in my task manager - well another problem to solve for tomorrow :-)

Labels: ,


Post a Comment

<< Home