how to install pgsql on Linux(Redhat9)

Hi there,

I have a simple Query. My activity is to install pgsql on Linux Redhat9. However I installed postgresql-7.3.2.tar.gz like this……..

[root]# cd /usr/local/src
[root]# gzip -cd postgresql-7.3.2.tar.gz | tar xvf -
[root]# cd postgresql-7.3.2
[root]# ./configure
[root]# make
[root]# make install
[root]# adduser postgres
[root]# mkdir /usr/local/pgsql/data
[root]# chown postgres /usr/local/pgsql/data
[root]# touch /var/log/pgsql
[root]# chown postgres /var/log/pgsql

But when I run the following command

[root@localhost root]# su postgres
[postgres@localhost root]$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

FATAL:  data directory "/usr/local/pgsql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700).
[postgres@localhost root]$

I am facing the above the Above Error………is there anybody to Help me.

And can I install pgsql through RPM ?? if yes plz give me Detail step by step Info…for that…..

I waiting for Reply ASAP.

Thanks in Advance.
Who is Participating?
rindiConnect With a Mentor Commented:
For your above installation you probably only need to run chmod on the folder as the postgres user and from inside the folder /usr/local/pqsql/:

chmod 700 data

You should be able to find rpm's for redhat9 via the fedora legacy project, which still has some support of the obsolete redhat 9 system:

the postgresql rpm is available in the following link:

and I suggest you also install yum, which is an update manager similar to debian's apt-get which you can use to manage software installations and updates:

Personaly I would suggest you upgrade to fedora-core 3, as this is the modern version of redhat and works stably (at least on my system).

Got exactly the same when I tried it, again on a redhat 9.0 system

rindi is correct in that you only need to chmod the folder, however you will find that it possibly needs to be:

chmod -R 700 data

This is definitely the case if you have used a previous version of pgsql on that system. Alternatively, the Redhat 9.0 discs have the RPM format for installing pgsql.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.