Installing Postgres: Difference between revisions

From NEOSYS Dev Wiki
Jump to navigationJump to search
m (Reverted edits by Anecada (Talk) to last revision by AlexNenko)
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
==Downloading and Installing PostgresSQL:==
==Downloading and Installing PostgresSQL:==


=== Postgres 8.3 ===
http://www.postgresql.org/ftp/binary/
http://www.enterprisedb.com/products/pgdownload.do
http://www.enterprisedb.com/products/pgdownload.do
X: drive below should be the same as the drive you build exodus otherwise the include files will not be found.


{|
{|
|+ Example Installation for Postgres 8.3
|QUESTION
|QUESTION
|RESPONSE
|RESPONSE
|COMMENT
|-
|-
|Installation Directory
|Installation Directory
|D:\Program Files\PostgreSQL\8.3
|X:\Program Files\PostgreSQL\8.3
|NB Keep the directory structure even if you change the drive otherwise will have to modify build project folder settings.
|-
|-
|Data Directory
|Data Directory
|D:\Program Files\PostgreSQL\8.3\data
|X:\Program Files\PostgreSQL\8.3\data
|Put this whereever you like
|-
|-
|password for superuser "postgres"<br>AND windows service
|password for superuser "postgres"<br>AND windows service
|yourpasshere
|yourpasshere
|Invent your own and TAKE A RECORD BECAUSE YOU WILL BE NEEDING IT LATER. If reinstalling enter the existing postgress user pass or delete the user and let it be recreated
|-
|-
|Port number the server should listen on
|Port number the server should listen on
|5432
|5432
|Exodus uses the default by default
|-
|-
|Locale:
|Locale:
|Default
|Default
|-
|Charset:
|UTF8 for server and client
|-
|Run StackBuilder:
|uncheck
|}
|}
=== Postgres 8.1 ===


[[Postgres 8.1]]
[[Postgres 8.1]]

Latest revision as of 14:00, 24 November 2010

Downloading and Installing PostgresSQL:

Postgres 8.3

http://www.postgresql.org/ftp/binary/ http://www.enterprisedb.com/products/pgdownload.do

X: drive below should be the same as the drive you build exodus otherwise the include files will not be found.

QUESTION RESPONSE COMMENT
Installation Directory X:\Program Files\PostgreSQL\8.3 NB Keep the directory structure even if you change the drive otherwise will have to modify build project folder settings.
Data Directory X:\Program Files\PostgreSQL\8.3\data Put this whereever you like
password for superuser "postgres"
AND windows service
yourpasshere Invent your own and TAKE A RECORD BECAUSE YOU WILL BE NEEDING IT LATER. If reinstalling enter the existing postgress user pass or delete the user and let it be recreated
Port number the server should listen on 5432 Exodus uses the default by default
Locale: Default
Charset: UTF8 for server and client
Run StackBuilder: uncheck

Postgres 8.1

Postgres 8.1