DokuWiki » Infrastructure » Operating System » Windows 7

h1. Install PostgreSQL 9.1

* Download @Postgresql@ from https://www.postgresql.org/download/windows/

* Install @Postgresql@ 

** follow all screens with default-value (just @NEXT@) until

!{width 500}postgres_install_password.png!

* enter @project-default@-password twice, the one starting with **"1"** and ending with **"s"**

* follow again all screens until copying of files starts

!{width 500}postgres_install_copy.png!

* as soon as copying has finished

* **uncheck** @launch stack-builder@

!{width 500}postgres_install_finish.png!

* Finish

h1. Restore production DB

open @console@ via @WINDOWS+r@ 

@cmd@

<pre><code class="bash">

"c:\Program Files (x86)\postgresql\9.1\bin\psql.exe" -U postgres -f "c:\users\OMB\Desktop\pg_dumpall.sql"

</code></pre>

enter the usual @project-password@

h1. Redirect DB from old server to new server

open @console@ via @WINDOWS+r@ 

@cmd@

<pre><code class="bash">

c:\windows\system32\odbcad32.exe

</code></pre>

* goto @System DSN@

!{width 500}postgres_odbc_1.png!

* select **12005** and @configure@

!{width 500}postgres_odbc_2.png!