how to install pgsql on Linux(Redhat9)

Posted on 2005-04-25
Last Modified: 2008-05-29
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.
Question by:Mohan_Hasa
    LVL 87

    Expert Comment

    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).

    LVL 87

    Accepted Solution

    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

    LVL 22

    Expert Comment

    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.


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Just about everyone has an old PC laying around.  Ask anyone in the IT industry, whether they are a professional or play in it as a hobby.  From outdated Desktops to cheap "throwaway" laptops, they are all around and not as hard to "fix up" as you m…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now