Forum OpenACS Q&A: Installing Postgresql

Collapse
Posted by Iuri Sampaio on
I’m installing openACS on my machine and I got troubles on postgresql’s installation.
There are no “/bin” and “/lib” sub-directories inside /usr/local/pgsql/
Then the file ~postgres/.bashrc is pointing to directories that are not there trying to reach the supporting libraries

The problem is that the directories should be already created there when I unpack the .tar file and create the user postgres

Then when I try to switch the user from root to postgres with: su – postgres. I got a slow reading that I need to press ctr+c to stop the process.

Do you know what it is?

Collapse
2: Re: Installing Postgresql (response to 1)
Posted by Steve Manning on
Unless you have a binary tarball, the /bin and /lib directories will only be created when you compile the source - follow the instructions here https://openacs.org/doc/current/postgres.html

- Steve
Collapse
3: Re: Installing Postgresql (response to 1)
Posted by Iuri Sampaio on
Thanks Steve.
I found out the bug.
I'd pasted the command line: source $HOME/.bashrc, in the wrong file.
I'd tought bashrc and bash_profile were the same file.
Now it's working fne

there is a bug on the documentation step 4
https://openacs.org/doc/current/postgres.html

the first block where it says:
[root src]# su - postgres
[postgres ~] emacs ~postgres/.bashrc

Paste this line into .bash_profile:

source $HOME/.bashrc

Paste these lines into .bashrc:

export PATH=/usr/local/bin/:$PATH:/usr/local/pgsql/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib

This is confusing because the user could think that bash_profile and bashrc are th same file. Once he already open the bashrc on emacs

did you understand what i said?
where can i posted that to someone update the documentation?

iuri

Collapse
4: Re: Installing Postgresql (response to 1)
Posted by Iuri Sampaio on
And now
i'm trying to compile and install postgres and got this error when i executed ./configure

checking for gcc: no
checking for cc: no
configure: error: no acceptable C compiler found in $PATH

How do i install gcc on SUSE 9.0?
I was browsing the gcc website and it says:

Source code for GCC releases may be downloaded from our mirror sites.

Important: because these are source releases, they will be of little use to you if you do not already have a C compiler on your machine. If you don't already have a compiler, you need pre-compiled binaries. Our binaries page has references to pre-compiled binaries for various platforms.

http://gcc.gnu.org/releases.html

Can anyone guide me on that??

best,
iuri

Collapse
Posted by Steve Manning on
You need gcc to compile postgresql, aolserver, tcl etc. all of which is supplied as source. Check out the Prerequisite Software page here https://openacs.org/doc/current/individual-programs.html to ensure you have the required bits before you start.

In Mandrake I would type 'urpmi gcc' to install it and any dependencies. You need to use the equivalent Suse package manager to install gcc. The answer will be in the Suse docs here http://www.novell.com/documentation/suse/index.html


- Steve