PostgreSQL fix for Red Hat 6.0

Tom Adelstein
writes:

On Jun 2nd, 23:31:42 Linux Today posted a fix to
PostgreSQL for Red Hat 5.2. We also knew that PostgreSQL 6.4 in Red
Hat 6.0 didn’t work under the normal installation routine. The
people at Hub and PostgreSql, Inc. took prompt action and provided
a fix for RH 6.0.

Linux users have used PostgreSQL for many years and it remains a
popular product. New users of Linux may find it a great choice for
many applications. Many thanks to the maintainers of the database
for the fix .

by: Jeff MacDonald
Tested on pII 233 with 128 megs of ram.
*************************

For some reason the install doesn’t create all of the
directories, so our job is to do that. That’s about all the extra
work it takes.

1. First of all su to root, like this
   

   penguin:~$ su –

2. get the rpm (postgres-6.4.2-3.rpm) from
   

   ftp.redhat.com ftp.cdrom.com or off the 6.0
   cd.

3. install it with
   

   penguin:~# rpm -i postgres-6.4.2-3.rpm

4. make the approiate directory for postgres you can call it what
   ever you prefer, just make sure to substitute /usr/local/pgsql with
   what ever you chose.

   penguin:~# mkdir /usr/local/pgsql

5. change ownership of /usr/local/pgsql to the postgres user
   

   penguin:~# chown postgres.postgres
   /usr/local/pgsql

6. su to user “postgres”
   

   penguin:~$ su – postgres

7. make the data directory
   

   penguin:~$ mkdir /usr/local/pgsql/data

8. run initdb
   

   penguin:~$ initdb –pglib=/usr/lib/pgsql
   –pgdata=/usr/local/pgsql/data

9. run the postmaster, play, and explore
   

   penguin:~$ postmaster -i &