asked on

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.

rindi

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:

http://fedoralegacy.org/download/

the postgresql rpm is available in the following link:

http://download.fedoralegacy.org/redhat/9/os/i386/

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:

http://download.fedoralegacy.org/redhat/9/legacy-utils/i386/

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

ASKER CERTIFIED SOLUTION

rindi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pjedmond

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.

HTH:)