Begin Tutorial

Contents

Downloading the PostgreSQL Database Packages

1. Point your web browser to https://www.sunfreeware.com and download the following four files for Solaris 10 SPARC:

   • postgresql-8.0.1-sol10-sparc-local.gz
   • libgcc-3.3-sol10-sparc-local.gz
   • zlib-1.2.3-sol10-sparc-local.gz
   • readline-5.1-sol10-sparc-local.gz

   In the right-hand frame, under Pick Processor/OS:, click SPARC/Solaris 10, then scroll down and find each package

2. In a terminal window as the root user, change to the directory where the files were downloaded.

3. Unpack each of the four archives using the gunzip utility:

   • gunzip postgresql-8.0.1-sol10-sparc-local.gz
   • gunzip libgcc-3.3-sol10-sparc-local.gz
   • gunzip zlib-1.2.3-sol10-sparc-local.gz
   • gunzip readline-5.1-sol10-sparc-local.gz

Installing the PostgreSQL Database

1. Install the libgcc package using the following command.

   When you are prompted for which package to process, press enter for all.
   When prompted to create a directory, enter y.

   # pkgadd -d libcc-3.3-sol10-sparc-local

2. Install the zlib package using the following command:

   When you are prompted for which package to process, press enter for all.

   # pkgadd -d zlib-1.2.3-sol10-sparc-local

3. Install the readline package using the following command.

   When prompted which package to process, press enter for all.

# pkgadd -d readline-5.1-sol10-sparc-local

4. Install the postgresql package using the following command.

   When prompted which package to process, press enter for all.
   When prompted to create a directory, enter y.

   # pkgadd -d postgresql-8.0.1-sol10-sparc-local

Configuring the PostgreSQL Database

1. Create a new Solaris user named postgres that owns the database.
   

   # useradd -d /export/home/postgres -g staff -s /bin/bash postgres

2. Set the password for the postgres user account to a password of your choice.

3. Create the home directory for the postgres user account.

   # mkdir /export/home/postgres

4. Set the ownership of the new home directory.

   # chown postgres /export/home/postgres # chgrp staff /export/home/postgres

5. Become the postgres user:

   # su - postgres

6. Create and edit the file /export/home/postgres/.profile using your favorite text editor, and insert the following lines.

   export PATH=$PATH:/usr/local/pgsql/bin:$HOME/bin export LD_LIBRARY_PATH=/usr/local/lib

7. Save the file and then re-source the profile.

   # . ./.profile

8. Create the following directories:

   # mkdir /export/home/postgres/data # mkdir /export/home/postgres/bin # mkdir /export/home/postgres/logs

9. Use the following command to start the database server.
   Optionally, create and edit the file /export/home/postgres/bin/dbstart using your favorite text editor, and insert the command.

   pg_ctl start -D /export/home/postgres/data -l export/home/postgres/logs/logfile

10. Use the following command to stop the database server.
    Optionally, create and edit the file /export/home/postgres/bin/dbshut using your favorite text editor, and insert the command.

    pg_ctl stop -D /export/home/postgres/data

11. To verify that the database server started or stopped successfully, execute the following command. You might also add this command to the dbstart and dbshut scripts.

    pg_ctl status -D /export/home/postgres/data

12. If you created the dbstart and dbshut scripts, make the new scripts executable.

# chmod +x /export/home/postgres/bin/*

13. Initialize the database instance:

    # initdb -D /export/home/postgres/data

14. Edit the file /export/home/postgres/data/postgresql.conf.

    Just after the following two lines:

    #listen_addresses = 'localhost' # what IP interface(s) to listen on; # defaults to localhost, '*' = any

    Add the following line:

    listen_addresses = '*'

15. Edit the file /export/home/postgres/data/pg_hba.conf as follows:

    a. Locate the following two lines:

    # IPv4 local connections: host all all 127.0.0.1/32 trust

    b. Add this line, replacing IP-address with the IP address of your machine:

    host all all IP-address/32 trust

16. Start the database server process by executing the dbstart command.

17. When you want to stop the database server, use the dbshut command.

Back to Top

Summary

In this quick start guide, you learned how to perform the following tasks:

• Install the PostgreSQL Database
• Configure the PostgreSQL Database

What To Do Next?