Linux Today: Linux News On Internet Time.

More on LinuxToday

PostgreSQL fix for Red Hat 6.0

Jun 07, 1999, 15:55 (16 Talkback[s])
(Other stories by Tom Adelstein)

WEBINAR: On-demand webcast

How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >

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 .

Instructions for installing PostgreSQL 6.4.2 on a RedHat 6.0.

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 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 &