What is pgsql-8.2.3Dc, the PostgreSQL 8.2.3Dc Database Server update for OpenServer 6.0.0? KEYWORDS: openserver 6.0.0 600 postgresql 823Dc database pgsql apache 2 2.2.6Cc install update libraries RELEASE: SCO OpenServer Release 6.0.0 PROBLEM: What is pgsql-8.2.3Dc, the PostgreSQL 8.2.3Dc Database Server update for OpenServer 6.0.0? SOLUTION: This PostgreSQL package updates the PostgreSQL Database Server on your OpenServer 6.0.0 System to 8.2.3Dc. This version of PostgreSQL fixes the following issues with the 8.2.3Db release that was included with OpenServer 6.0.0 Maintenance Pack 3: Fixes potential conflicts with the version of the OpenSSL libraries. In addition, the shared library, /usr/lib/libpq.so, included with the PostgreSQL package incremented its version number thus causing incompatibilities with previously compiled PostgreSQL applications. ftp://ftp.sco.com/pub/openserver6/600/other/pgsql.8.2.3Dc ------------------------------------------------------------- I. Software Notes and Recommendations 1. This supplement can be installed on the following SCO OpenServer 6.0.0 systems with the following Supplements installed: SCO OpenServer 6.0.0 Maintenance Pack 3 Maintenace Pack 3 is available to download from: http://www.sco.com/support/update/download/product.php?pfid=12&prid=20 ------------------------------------------------------------- II. Installation Instructions NOTE: If you have a release of PostgreSQL on your system prior to 8.2.3Db (This version was included with Maintenance Pack 3) then please follow the instructions at: ftp://ftp.sco.com/pub/openserver6/600/mp/osr600mp3/osr600mp3.html#1.7 to backup your existing databases prior to installing this update. If you have 8.2.3Db installed then when you see the prompt during installation you can select "OK" when prompted to continue the installation without the need to backup the existing databases. To install PostgreSQL 8.2.3Dc follow these steps: 1. Login as root 2. Create an empty directory, such as /tmp/pgsql, to which the patch will be downloaded. 3. Download the PostgreSQL 8.2.3Dc patch archive, pgsql-8.2.3Dc-VOLS.tar from: ftp://ftp.sco.com/pub/openserver6/600/other/pgsql.8.2.3Dc to the directory created in step 2. 4. Extract the downloaded archive using: cd /tmp/pgsql tar xvf pgsql-8.2.3Dc-VOLS.tar 5. Run the Software Manager with the command: scoadmin software or double-click on the Software Manager icon in the desktop. 6. Pull down the "Software" menu and select "Install New". 7. When prompted for the host from which to install, choose the local machine and then "Continue". 8. In the "Select Media" menu, pull down the "Media Device" menu. Select "Media Images", then choose "Continue". 9. When prompted for the "Image Directory", enter "/tmp/pgsql" (or the directory where you placed the pgsql-8.2.3Dc-VOLS.tar file in step 2) and choose "OK." 10. When prompted to select software to install, make sure that the "pgsql - PostgreSQL Database Management System (ver 8.2.3Dc)" entry is highlighted. Choose "Install". 11. Once installation of the PostgreSQL Database has completed, exit the Software Manager by selecting "Exit" from the "Host" menu. 12. If desired, remove or archive the downloaded patch file and remove the containing directory created in step 2. ------------------------------------------------------------- III. Configuration Instructions To configure or modify the current PostgreSQL configuration, as root run: mkdev pgsql ------------------------------------------------------------- IV. Removal Instructions 1. Log in as root. 2. Execute the command: scoadmin software or double-click on the Software Manager icon in the desktop. 3. Highlight the "pgsql - PostgreSQL Database Management System (ver 8.2.3Dc)" entry. 4. Pull down the "Software" menu and select "Remove Software". 5. Once the removal finishes, quit the Software Manager.