Postgres 8.1: Difference between revisions

From NEOSYS Dev Wiki
Jump to navigationJump to search
No edit summary
m (Reverted edits by Anecada (Talk) to last revision by Steve)
 
Line 1: Line 1:
----
===Part 1: Downloading & Installing PostgresSQL===
<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://abaviteha.co.cc Under Construction! Please Visit Reserve Page. Page Will Be Available Shortly]=
----
=[http://abaviteha.co.cc CLICK HERE]=
----
</div>
===Part 1: Downloading &amp; Installing PostgresSQL===


# Go to http://www.postgresql.org/
# Go to http://www.postgresql.org/
# In the search engine at the top right hand corner copy &amp; paste &lt;B&gt;postgresql-8.1.9-1.zip&lt;/b&gt; 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.
# 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.
# Click the one pointed to you by the red arrow&lt;br&gt;[[Image:getpgSQL1.jpg]]&lt;br&gt;if not included, look for something similar, keeping in mind you need the &lt;B&gt;postgresql-8.1.9-1.zip&lt;/b&gt;)
# 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>)
# Click on the link shown to you by the red arrow; &quot;postgresql-8.2.5-1.zip&quot; &lt;br&gt;[[Image:FTPbrowser.JPG]]
# Click on the link shown to you by the red arrow; "postgresql-8.2.5-1.zip" <br>[[Image:FTPbrowser.JPG]]
# Find the flag of the country you are in, and click the Ftp link under the flag.
# 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.  
# 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.  
Line 20: Line 12:
# 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.
# 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)
# 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.&lt;br&gt;
# This window is important, so don't miss any thing out.<br>
[[Image:postgreSQL2.JPG]]&lt;br&gt;
[[Image:postgreSQL2.JPG]]<br>
#* Scroll down to Database drivers, and click on the small triangle pointing downwards, a small list of options will appear click &quot;Entire feature will be unavailable&quot;.
#* 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 &quot;Entire feature will be installed on your local driver&quot;. Click Next.
#* 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.&lt;br&gt; If your reinstalling PostgreSQL, delete the existing account name; by going to Computer Management, System tools, Local Users &amp; Groups and then users. Finally delete postgreSQL.&lt;br&gt;
# 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>
# Click yes:&lt;br&gt;[[Image:accounterror.JPG]]&lt;br&gt;
# Click yes:<br>[[Image:accounterror.JPG]]<br>
# Then click Next. Click Yes. Click Ok.
# Then click Next. Click Yes. Click Ok.
# In the current window there are some drop down menus you MUST change:  
# In the current window there are some drop down menus you MUST change:  
Line 31: Line 23:
#* The field next to Locale, use the drop down menu to find your language.
#* The field next to Locale, use the drop down menu to find your language.
# Type in a password and take a note of it.
# 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:&lt;br&gt;[[Image:checkup.jpg]]&lt;br&gt;
#* 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.
# 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 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.
# Then to start the Installation click Next.


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


# Go to your start menu, all programs, PostgreSQL 8.1, pgadmin III. Click the close button for the tips.
# Go to your start menu, all programs, PostgreSQL 8.1, pgadmin III. Click the close button for the tips.
Line 43: Line 35:
# On the right hand side of the window look for Login Roles (1), at the bottom of the list.
# 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.
# Right click it and click the New Login Role.
# Type in NEOSYS into the name field&lt;br&gt;[[Image:loginrole.JPG]]&lt;br&gt;
# Type in NEOSYS into the name field<br>[[Image:loginrole.JPG]]<br>
# Type in a pass and make a note of it.
# Type in a pass and make a note of it.

Latest revision as of 13:55, 24 November 2010

Part 1: Downloading & Installing PostgresSQL

  1. Go to http://www.postgresql.org/
  2. 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.
  3. Click the one pointed to you by the red arrow
    GetpgSQL1.jpg
    if not included, look for something similar, keeping in mind you need the postgresql-8.1.9-1.zip)
  4. Click on the link shown to you by the red arrow; "postgresql-8.2.5-1.zip"
    FTPbrowser.JPG
  5. Find the flag of the country you are in, and click the Ftp link under the flag.
  6. 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.
  7. Look in your download folder for postgresql-8.1.9-1.zip
  8. Right click on postgresql-8.1.9-1.zip click Extract to postgresql-v8.1.9-1.zip\
  9. Go to the folder you just extracted to in your download folder.
  10. 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.
  11. 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)
  12. This window is important, so don't miss any thing out.

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.
  1. 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.
  2. Click yes:
    Accounterror.JPG
  3. Then click Next. Click Yes. Click Ok.
  4. 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.
  5. 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:
      Checkup.jpg
  6. In the next window, just click next.
  7. Then you come to a window called Enable contrib modules, tick Tsearch2 near the right hand side and click Next.
  8. Then to start the Installation click Next.

Part 2: Set-up & Configuration

  1. Go to your start menu, all programs, PostgreSQL 8.1, pgadmin III. Click the close button for the tips.
  2. 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.
  3. 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.
  4. On the right hand side of the window look for Login Roles (1), at the bottom of the list.
  5. Right click it and click the New Login Role.
  6. Type in NEOSYS into the name field
    Loginrole.JPG
  7. Type in a pass and make a note of it.