Feb 28, 2013

PostgreSQL Binary Install in Win7



  • download binary files: http://www.enterprisedb.com/products-services-training/pgbindownload
  • unzip to c:\pgsql
  • create a batch file: setevn.bat:
      set PGHOME=C:\pgsql
      set PATH=%PGHOME%\bin;%path%
      set PGHOST=localhost
      set PGLIB=%PGHOME%\lib
      set PGDATA=%PGHOME%\data
  • as a system administrator to run the "command prompt"
  • execute the following script:
  •           C:\>cd C:\pgsql
      C:\pgsql>setenv.bat
      C:\pgsql>initdb.exe -D %PGDATA% -E UTF8 --locale=C
      C:\pgsql>pg_ctl.exe register -D %PGDATA% -N "PostgreSQL 918"

No comments: