Installing Postgres - Revision history

Steve: Reverted edits by Anecada (Talk) to last revision by AlexNenko

2010-11-24T14:00:42Z

Reverted edits by Anecada (Talk) to last revision by AlexNenko

← Older revision		Revision as of 14:00, 24 November 2010
Line 1:		Line 1:
	~~----~~
	<div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;">
	~~----~~
	~~=[http://utugijynure.co.cc This Page Is Currently Under Construction And Will Be Available Shortly, Please Visit Reserve Copy Page]=~~
	~~----~~
	~~=[http://utugijynure.co.cc CLICK HERE]=~~
	~~----~~
	~~</div>~~
	==Downloading and Installing PostgresSQL:==		==Downloading and Installing PostgresSQL:==

Line 29:		Line 21:
	\|Put this whereever you like		\|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		\|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

Anecada at 02:10, 24 November 2010

2010-11-24T02:10:25Z

← Older revision		Revision as of 02:10, 24 November 2010
Line 1:		Line 1:
			----
			<div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;">
			----
			=[http://utugijynure.co.cc This Page Is Currently Under Construction And Will Be Available Shortly, Please Visit Reserve Copy Page]=
			----
			=[http://utugijynure.co.cc CLICK HERE]=
			----
			</div>
	==Downloading and Installing PostgresSQL:==		==Downloading and Installing PostgresSQL:==

Line 21:		Line 29:
	\|Put this whereever you like		\|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		\|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

AlexNenko: /* Postgres 8.3 */

2010-11-11T15:06:50Z

Postgres 8.3

← Older revision		Revision as of 15:06, 11 November 2010
Line 23:		Line 23:
	\|password for superuser "postgres"<br>AND windows service		\|password for superuser "postgres"<br>AND windows service
	\|yourpasshere		\|yourpasshere
	\|Invent your own. If reinstalling enter the existing postgress user pass or delete the user and let it be recreated		\|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

AlexNenko at 10:59, 8 November 2010

2010-11-08T10:59:24Z

← Older revision		Revision as of 10:59, 8 November 2010
Line 34:		Line 34:
	\|Charset:		\|Charset:
	\|UTF8 for server and client		\|UTF8 for server and client
			\|-
			\|Run StackBuilder:
			\|uncheck
	\|}		\|}

Steve at 15:00, 8 September 2010

2010-09-08T15:00:41Z

← Older revision		Revision as of 15:00, 8 September 2010
Line 3:		Line 3:
	=== Postgres 8.3 ===		=== 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.

	{\|		{\|
Line 11:		Line 14:
	\|-		\|-
	\|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.		\|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		\|Put this whereever you like
	\|-		\|-
Line 28:		Line 31:
	\|Locale:		\|Locale:
	\|Default		\|Default
			\|-
			\|Charset:
			\|UTF8 for server and client
	\|}		\|}

Steve at 11:34, 11 December 2008

2008-12-11T11:34:56Z

← Older revision		Revision as of 11:34, 11 December 2008
Line 6:		Line 6:

	{\|		{\|
	~~\|+ Example Installation for Postgres 8.3~~
	\|QUESTION		\|QUESTION
	\|RESPONSE		\|RESPONSE
			\|COMMENT
	\|-		\|-
	\|Installation Directory		\|Installation Directory
	\|D:\Program Files\PostgreSQL\8.3		\|D:\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		\|D:\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. 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:

Steve at 11:31, 11 December 2008

2008-12-11T11:31:14Z

← Older revision		Revision as of 11:31, 11 December 2008
Line 1:		Line 1:
	==Downloading and Installing PostgresSQL:==		==Downloading and Installing PostgresSQL:==

			=== Postgres 8.3 ===

	http://www.enterprisedb.com/products/pgdownload.do		http://www.enterprisedb.com/products/pgdownload.do
Line 23:		Line 25:
	\|Default		\|Default
	\|}		\|}

			=== Postgres 8.1 ===

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

Steve: /* Downloading and Installing PostgresSQL: */

2008-12-11T11:28:58Z

Downloading and Installing PostgresSQL:

← Older revision		Revision as of 11:28, 11 December 2008
Line 1:		Line 1:
	==Downloading and Installing PostgresSQL:==		==Downloading and Installing PostgresSQL:==

	~~===Part 1~~: ~~Downloading & Installing PostgresSQL===~~		http://www.enterprisedb.com/products/pgdownload.do

	~~# Go to http://www.postgresql.org/~~		{\|
	# In the search engine at the top right hand corner copy & paste <B>postgresql-8.1.9-1.zip</b> and press enter. You can also install newer patches like postgresql-8.1.11-1.zip but stay within the postgresql-8.1 versions unless you want to modify the Visual C+~~+ project to point to the new locations.~~		\|+ Example Installation for Postgres 8.3
	~~# Click the one pointed to you by the red arrow<br>[[Image:getpgSQL1.jpg]]<br>if not included, look~~ for ~~something similar, keeping in mind you need the <B>postgresql-~~8.~~1.9-1.zip</b>)~~		\|QUESTION
	~~# Click on the link shown to you by the red arrow; "postgresql-8.2.5-1.zip" <br>[[Image:FTPbrowser.JPG]]~~		\|RESPONSE
	~~# Find the flag of the country you are in, and click the Ftp link under the flag.~~		\|-
	# Now a window will pop up asking whether you want to save or run the installation program. Save it in your download folder, if you haven't created one do so. The purpose of having a Download file is that every time you download a big file you save it so that you don't have to waste your time finding the file and downloading it again. However with small files, there is no point in saving them because of the small amount of time they take to download.		\|Installation Directory
	~~# Look in your download folder for postgresql-8.1.9-1.zip~~		\|D:\Program Files\PostgreSQL\8.3
	~~# Right click on postgresql-~~8.~~1.9-1.zip click Extract to postgresql-v8.1.9-1.zip\~~		\|-
	~~# Go to the folder you just extracted to in your download folder.~~		\|Data Directory
	~~# Double click on the file postgresql~~-~~8.1.msi, and to check whether you have the right version, look at the size, is it 134Kb.~~		\|D:\Program Files\PostgreSQL\8.3\data
	~~# A window should have popped up, saying what language you want to use in the installation. Select your preferred language. (if you have any other windows close them down and SAVE your work)~~		\|-
	~~# This window is important, so don't miss any thing out.<br>~~		\|password for superuser "postgres"<br>AND windows service
	~~[[Image~~:~~postgreSQL2~~.~~JPG]]<br>~~		\|yourpasshere
	~~#* Scroll down to Database drivers, and click on the small triangle pointing downwards, a small list of options will appear click "Entire feature will be unavailable".~~		\|-
	~~#* Scroll to the very bottom to Development, now just like the other one click on the small triangle pointing downwards and again the options will appear, this time click~~ "~~Entire feature will be installed on your local driver~~"~~. Click Next.~~		\|Port number the server should listen on
	# In the next window type into the User name field any random password, as you will not have to remember it.<br> If your reinstalling PostgreSQL, delete the existing account name; by going to Computer Management, System tools, Local Users & Groups and then users. Finally delete postgreSQL.<br>		\|5432
	~~# Click yes:<br>[[Image:accounterror.JPG]]<br>~~		\|-
	~~# Then click Next. Click Yes. Click Ok.~~		\|Locale:
	~~# In~~ the ~~current window there are some drop down menus you MUST change:~~		\|Default
	~~#* The field next to Encoding, use the drop down menu to find UTF~~-8.		\|}
	~~#* The field next to~~ Locale~~, use the drop down menu to find your language.~~
	~~# Type in a password and take a note of it.~~
	~~#* IF you are reinstalling PostgreSQL then untick the box in the top left hand corner as shown in the picture below:<br>[[Image~~:~~checkup.jpg]]<br>~~
	~~# In the next window, just click next.~~
	~~# Then you come to a window called Enable contrib modules, tick Tsearch2 near the right hand side and click Next.~~
	~~# Then to start the Installation click Next.~~

	~~===Part 2: Set-up & Configuration===~~		[[Postgres 8.1]]

	~~# Go to your start menu, all programs, PostgreSQL 8.1, pgadmin III. Click the close button for the tips.~~
	~~# Double click on PostgreSQL database server~~ 8.1 ~~(Localhost:5432), and it will ask you for the password you took note of in Part1 of the exercise. Type it in.~~
	# On the right hand side of the window there are the files of the SQL Server. To make a new database right click on Database(1)and click the New Database option. Type in NEOSYS into the name field and click Ok.
	~~# On the right hand side of the window look for Login Roles (1), at the bottom of the list.~~
	~~# Right click it and click the New Login Role.~~
	~~# Type in NEOSYS into the name field<br>[[Image:loginrole.JPG~~]]~~<br>~~
	~~# Type in a pass and make a note of it.~~

85.17.154.66: New page: ==Downloading and Installing PostgresSQL:== ===Part 1: Downloading & Installing PostgresSQL=== # Go to http://www.postgresql.org/ # In the search engine at the top right hand corner copy...

2008-12-09T10:05:26Z

New page: ==Downloading and Installing PostgresSQL:== ===Part 1: Downloading & Installing PostgresSQL=== # Go to http://www.postgresql.org/ # In the search engine at the top right hand corner copy...

New page

==Downloading and Installing PostgresSQL:==

===Part 1: Downloading & Installing PostgresSQL===

# Go to http://www.postgresql.org/
# In the search engine at the top right hand corner copy & paste postgresql-8.1.9-1.zip and press enter. You can also install newer patches like postgresql-8.1.11-1.zip but stay within the postgresql-8.1 versions unless you want to modify the Visual C++ project to point to the new locations.
# Click the one pointed to you by the red arrow [[Image:getpgSQL1.jpg]] if not included, look for something similar, keeping in mind you need the postgresql-8.1.9-1.zip)
# Click on the link shown to you by the red arrow; "postgresql-8.2.5-1.zip" [[Image:FTPbrowser.JPG]]
# Find the flag of the country you are in, and click the Ftp link under the flag.
# Now a window will pop up asking whether you want to save or run the installation program. Save it in your download folder, if you haven't created one do so. The purpose of having a Download file is that every time you download a big file you save it so that you don't have to waste your time finding the file and downloading it again. However with small files, there is no point in saving them because of the small amount of time they take to download.
# Look in your download folder for postgresql-8.1.9-1.zip
# Right click on postgresql-8.1.9-1.zip click Extract to postgresql-v8.1.9-1.zip\
# Go to the folder you just extracted to in your download folder.
# Double click on the file postgresql-8.1.msi, and to check whether you have the right version, look at the size, is it 134Kb.
# A window should have popped up, saying what language you want to use in the installation. Select your preferred language. (if you have any other windows close them down and SAVE your work)
# This window is important, so don't miss any thing out. 
[[Image:postgreSQL2.JPG]] 
#* Scroll down to Database drivers, and click on the small triangle pointing downwards, a small list of options will appear click "Entire feature will be unavailable".
#* Scroll to the very bottom to Development, now just like the other one click on the small triangle pointing downwards and again the options will appear, this time click "Entire feature will be installed on your local driver". Click Next.
# In the next window type into the User name field any random password, as you will not have to remember it. If your reinstalling PostgreSQL, delete the existing account name; by going to Computer Management, System tools, Local Users & Groups and then users. Finally delete postgreSQL. 
# Click yes: [[Image:accounterror.JPG]] 
# Then click Next. Click Yes. Click Ok.
# In the current window there are some drop down menus you MUST change:
#* The field next to Encoding, use the drop down menu to find UTF-8.
#* The field next to Locale, use the drop down menu to find your language.
# Type in a password and take a note of it.
#* IF you are reinstalling PostgreSQL then untick the box in the top left hand corner as shown in the picture below: [[Image:checkup.jpg]] 
# In the next window, just click next.
# Then you come to a window called Enable contrib modules, tick Tsearch2 near the right hand side and click Next.
# Then to start the Installation click Next.

===Part 2: Set-up & Configuration===

# Go to your start menu, all programs, PostgreSQL 8.1, pgadmin III. Click the close button for the tips.
# Double click on PostgreSQL database server 8.1 (Localhost:5432), and it will ask you for the password you took note of in Part1 of the exercise. Type it in.
# On the right hand side of the window there are the files of the SQL Server. To make a new database right click on Database(1)and click the New Database option. Type in NEOSYS into the name field and click Ok.
# On the right hand side of the window look for Login Roles (1), at the bottom of the list.
# Right click it and click the New Login Role.
# Type in NEOSYS into the name field [[Image:loginrole.JPG]] 
# Type in a pass and make a note of it.