Installing Postgres: Difference between revisions
From NEOSYS Dev Wiki
Jump to navigationJump to search
(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. | |||
{| | {| | ||
|QUESTION | |QUESTION | ||
|RESPONSE | |RESPONSE | ||
|COMMENT | |||
|- | |- | ||
|Installation Directory | |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 | |Data Directory | ||
| | |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 |