Installing_PostgreSQL

This procedure covers the installation of PostgreSQL.

Linux

1. Get the PostgreSQL installation package by doing one of the following:

• download PostgreSQL from PostgreSQL downloads page
• install it via your distribution's package management system
• run the following from the command-line:

Ubuntu

sudo apt-get install postgresql-8.3

Fedora

sudo yum groupinstall "PostgreSQL Database"

2. Fedora only. Initialise the database system:

sudo service postgresql initdb

3. Fedora only. Start the postgres service:

sudo service postgresql start

4. Test the server is running on port 5432:

netstat -ltn

5. Become root:

sudo su -

6. Enter your root password

7. Switch to the postgres user:

su - postgres

8. Log into the database:

psql

9. Change the postgres password:

ALTER USER postgres WITH PASSWORD '<enter postgres password>

Result: If ALTER ROLE is displayed, you have successfully changed the postgres database superuser password.

10. Exit:

\q

11. Exit back to the root shell:

exit

Windows

1. Download PostgreSQL from PostgreSQL downloads page

2. Run the PostgreSQL executable

Result: The setup wizard starts.

3. Click Next

4. In the Installation Directory screen, select default location and click Next

5. In the Data Directory screen, select the default data directory and click Next

6. In the Password screen, enter the password for the database superuser, repeat and click Next

7. In the Port screen, check port number is 5432 and click Next

8. In the Advanced Options screen, click Next

Result: The Ready to Install screen is displayed.

9. Click Next

Result: The setup wizard completes the installation. Note: Once installation is completed, do not proceed to the Stack Builder installation, click Cancel.