charupload

Manual installation of postgresql under administrator user in windows

with one comment

Since version 8.2.7, postgresql on windows can run under administrative user account. Here’s how to do it with postgresql 8.3.3

1) Download postgresql-8.3.3-1-binaries-no-installer.zip. Here we’ll use c:\postgresql as the target directory, so extract the archive to that directory.
2) Create a folder named data in c:\postgresql (or wherever you want it to be). Then we’ll need to initialize the data folder. Run this command:
c:\postgresql\bin\initdb -D c:\postgresql\data
3) Run the server
pg_ctl.exe start -D c:\postgresql\data

NOTE:
1) the fix to run postgresql under administrator is in pg_ctl.exe so don’t run postgres.exe directly or it will fail.
2) this setup is for testing purpose, don’t use it for production use.

Written by char101

July 26, 2008 at 8:54 am

Posted in Uncategorized

One Response

Subscribe to comments with RSS.

  1. i cann’t install properly on win xp

    kamlesh

    September 11, 2009 at 9:09 am


Leave a Reply