Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


PostgreSQL fix for Red Hat 6.0

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

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