PostgreSQL 7.0.3+Apache+PHP 4.0.3

etiquet

Trying to install the following configuration :

Apache 1.3.17
Php 4.0.4pl1
PostgreSQL 7.0.3

on a Redhat 7.0 distribution.

Try to build by hand postgre..OK
Launching > Got an sharing memory error when launching postmaster...

Try to install from RPM postgre, server,devel,odbc... OK

Compiling PHP ok
Compiling Apache :
error :
php-4.0.4pl1/ext/pgsql/pgsql.c:1809: undefined reference to `pg_en
coding_to_char'

Does someone know how to best install those deamons. Is redhat 7.0 ok.

Thank you very much.

Eric

smarlowe

I've installed just that.

When installing postgresql, it is likely that it has placed it's lib file in a directory the OS doesn't know to look in, so that's likly the "shared memory error" you're mentioning. (i.e. can't find shared library). If it really is a shared memory problem, then I'm not sure what to do, as I've only run into that problem on slolaris.

To tell linux about your lib files, edit /etc/ld.so.conf and add a line with the path to the postgresql libs, then run ldconfig or reboot.

Next you run initdb to create the initial database.

After compiling and installing postgres, you have to run it as something other than the root (for security reasons, postmaster will refuse to run as a priviledged account)

It is best to make an account that does just this.

Try reading the INSTALL file for postgresql, it is very long and detailed.

For apache, read the README.configure file and find the section on DSO config. Use the shared=max modules=most setup, which will install all kinds of junk via DSO you can turn off with the httpd.conf file.

After postgres and apache are done, the only switches you need for php are the --with-apxs=/www/bin/apxs and --with-pgsql=/path/to/pgsql

and make and make install. Then type httpd as root to start the web server.

etiquet

Before reading your mail, I've been trying another way. I install it with RH rpm's.
Maybe it is not the best way, but it works enough for testing purpose.

I'm sure the problem, I had where really a shared memory problem (found dozen web pages on this particular problem), maybe there is a flag somewhere for linux best compile, but don't have time now to find it !

About apache compilation error, I just stay @1.3.12 before finding a good/simple installation process.

Thank you.
Eric

Scott Marlowe wrote:

I've installed just that.

To tell linux about your lib files, edit /etc/ld.so.conf and add a line with the path to the postgresql libs, then run ldconfig or reboot.

Next you run initdb to create the initial database.

After compiling and installing postgres, you have to run it as something other than the root (for security reasons, postmaster will refuse to run as a priviledged account)

It is best to make an account that does just this.

Try reading the INSTALL file for postgresql, it is very long and detailed.

For apache, read the README.configure file and find the section on DSO config. Use the shared=max modules=most setup, which wi....

smarlowe

Can you cut and paste the EXACT error message here for me to read so I can try to figure out what it means?

smarlowe

Oh, and what options are being passed to the postmaster.

The most common "shared memory error" from postgresql is that you have to declare two buffers for each possible backend, and most linux kernels can't handle enough shared buffers to handle more than a thousand to so front ends max.

The switches are -N and -B by the way, so if you had -N 64 then -B would have to be -B 128 or higher.

etiquet

I did follow the Install instruction, so :

the compilation string woes :
./configure --with-odbc --with-perl

the Startup string woes.

pathto/postmaster -D pathto/data

eric

etiquet

I did follow the Install instruction, so :

the compilation string woes :
./configure --with-odbc --with-perl

the Startup string woes.

pathto/postmaster -D pathto/data

Thank you for your help.
Eric

smarlowe

Yes, but you still haven't shown me the actual error message, which is one of the two things I was hoping for. If you could cut and paste that in that really would help in troubleshooting this.