Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Site Map
Support Solutions to help you do business with your Virtual Server.

Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


PostgreSQL Overview
PostgreSQLPostgreSQL is a powerful relational database management system (rdbms) that is similar to Ingres. PostgreSQL is an enhancement of the original POSTGRES database management system, a next-generation DBMS research prototype. While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL.

While Blue Reef offers PostgreSQL for free of charge to our Virtual Server Administrators, we recommend that you take the time to register at the PostgreSQL web site.

  1. Connect to your Virtual Server using Telnet or SSH.
  2. Add the following lines to your shell startup file. To find out which shell you are using, type
        % echo $SHELL
    and the name of the shell will appear.
    1. If you are using csh or one of its variants, then add the following lines to the ~/.cshrc file on your Virtual Server:
           setenv PGDATA /usr/local/pgsql/data
           setenv PGLIB /usr/local/pgsql/lib
           setenv LD_LIBRARY_PATH /usr/local/pgsql/lib
           set path = (/usr/local/pgsql/bin $path)
    2. If you are using the Bourne shell (/bin/sh or /bin/bash) then add the following lines to the ~/.profile file on your Virtual Server:
  3. Install PostgreSQL:

        % vinstall pgsql

    This program installs all the necessary PostgreSQL files and initializes a database with the same name as your user name. It also starts the postmaster daemon running.

  4. The main tool for using PostgreSQL is the psql client server. To start it type:

        % virtual psql

    The psql client server will start up and you will be able to type in SQL code and ask for help.
    If you get the following error:
         Connection to database '(null)' failed.
         FATAL: PQsetdb: Unable to determine a Postgres username!
    all you need do is type:

        % vpwd_mkdb ~/etc/passwd

    This program will read your password file at ~/etc/passwd and create a Berkeley DB format file. PostgreSQL uses this new file to look up user names and account information.
To uninstall PostgreSQL on your Virtual Server, connect to your Virtual Server via Telnet or SSH and do the following:
    % cd ~/usr/local
    % chmod -R u+w pgsql
    % rm -rf pgsql
Next, edit your ~/etc/rc file and remove the line that contains postgresql. Then run the ps command, like this:
    % ps -x
Locate the process ID of the PostgreSQL daemon and use kill to stop the PostgreSQL daemon:
    % kill process_ID
Documentation and Support

PHP Development


mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons


Programming the Perl DBI
Programming the Perl DBI




Building Database Applications on the Web Using PHP3
Building Database Applications on the Web Using PHP3


The Data Webhouse Toolkit
The Data Webhouse Toolkit


PHP3 and MySQL Web Development
$39.99 logo
Search for :
Enter keywords...