Manual installation of postgresql under administrator user in windows

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 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

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.

  1. i cann’t install properly on win xp

  2. I’d like , please toplist lolita

    • Anon2012
    • November 11th, 2012

    You saved my day. Thnx

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: