Thread: Hi
Hi, I am very new to this group. First I greet all in here. I have a Major Problem: I am using a RaQ3 and i would love to use Postgres 7.1. Now, as some of you might know, the Cobalt Internal Interface is driven by Postgres v6.5.3. I already tried to upgrade the Postgres Version, but I smashed the interface. I did not manage to reconnect the interface logic with the new Postgres Version. Now, maybe anyone of you knows a way to proceed the upgrade , or, and the is what I think is the better option: What would I need to do to run 2 Versions of Postgres on the RaQ3? Also, I do not know what the cobalt internal runtime status monitor is saying about 2 postgres .... ? Any idea? Regards, Alex -- ___________________________ Alexander Lohse Human Touch Medienproduktion GmbH Am See 1 17440 Klein Jasedow Tel: (038374) 75211 Fax: (038374) 75223 eMail: al@humantouch.de http://www.humantouch.de
Alexander Lohse <al@humantouch.de> writes:
> What would I need to do to run 2 Versions of Postgres on the RaQ3?
Should be the same deal as for running 2 versions anyplace else:
give them separate install directories, separate data directories,
and separate port numbers. If you compile from source then you can
make these changes with configure's --prefix and --with-portnum
switches. Not sure you can do it easily with an RPM-based install.
On some systems you may run into kernel limits on SysV shared memory
and/or semaphores when trying to run 2 or more postmasters. See the
documentation about raising kernel limits if so.
regards, tom lane
>Alexander Lohse <al@humantouch.de> writes: >> What would I need to do to run 2 Versions of Postgres on the RaQ3? > >Should be the same deal as for running 2 versions anyplace else: >give them separate install directories, separate data directories, >and separate port numbers. If you compile from source then you can >make these changes with configure's --prefix and --with-portnum >switches. Not sure you can do it easily with an RPM-based install. > >On some systems you may run into kernel limits on SysV shared memory >and/or semaphores when trying to run 2 or more postmasters. See the >documentation about raising kernel limits if so. > > regards, tom lane Hi Tom, I successfully dowloaded the latest PG version via cvs, compiled and installed user ... Seems to work. Now I am trying to recompile php to connect to this new install in /home/pgsql7 I get the follwing error: Making all in pgsql make[2]: Entering directory `/root/php-4.0.4pl1/ext/pgsql' make[3]: Entering directory `/root/php-4.0.4pl1/ext/pgsql' /bin/sh /root/php-4.0.4pl1/libtool --silent --mode=compile gcc -I. -I/root/php-4.0.4pl1/ext/pgsql -I/root/php-4.0.4pl1/main -I/rootp php-4.0.4pl1 -I/usr/include/apache -I/root/php-4.0.4pl1/Zend -I/usr/local/include -I/root/php-4.0.4pl1/ext/mysql/libmysql -I/root/ph- -4.0.4pl1/ext/xml/expat/xmltok -I/root/php-4.0.4pl1/ext/xml/expat/xmlparse -I/root/php-4.0.4pl1/TSRM -I/home/pgsql7/include -DLINUX= -DNO_DBM_REWRITEMAP -DMOD_SSL=202108 -DMOD_PERL -DUSE_PERL_SSI -Dbool=char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -X XML_BYTE_ORDER=12 -g -O2 -c pgsql.c In file included from pgsql.c:29: php_pgsql.h:32: postgres.h: No such file or directory make[3]: *** [pgsql.lo] Error 1 make[3]: Leaving directory `/root/php-4.0.4pl1/ext/pgsql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/root/php-4.0.4pl1/ext/pgsql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/php-4.0.4pl1/ext' make: *** [all-recursive] Error 1 I did : ./configure '--with-mysql' '--with-pgsql=/home/pgsql7' ..... Do you have any idea? Thanx in advance, Alex -- ___________________________ Alexander Lohse Human Touch Medienproduktion GmbH Am See 1 17440 Klein Jasedow Tel: (038374) 75211 Fax: (038374) 75223 eMail: al@humantouch.de http://www.humantouch.de
Alexander Lohse <al@humantouch.de> writes:
> make[3]: Entering directory `/root/php-4.0.4pl1/ext/pgsql'
> /bin/sh /root/php-4.0.4pl1/libtool --silent --mode=compile gcc -I.
> -I/root/php-4.0.4pl1/ext/pgsql -I/root/php-4.0.4pl1/main -I/rootp
> php-4.0.4pl1 -I/usr/include/apache -I/root/php-4.0.4pl1/Zend
> -I/usr/local/include -I/root/php-4.0.4pl1/ext/mysql/libmysql
> -I/root/ph-
> -4.0.4pl1/ext/xml/expat/xmltok
> -I/root/php-4.0.4pl1/ext/xml/expat/xmlparse -I/root/php-4.0.4pl1/TSRM
> -I/home/pgsql7/include -DLINUX=
> -DNO_DBM_REWRITEMAP -DMOD_SSL=202108 -DMOD_PERL -DUSE_PERL_SSI
> -Dbool=char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -X
> XML_BYTE_ORDER=12 -g -O2 -c pgsql.c
> In file included from pgsql.c:29:
> php_pgsql.h:32: postgres.h: No such file or directory
> make[3]: *** [pgsql.lo] Error 1
Change php_pgsql.h to refer to postgres_fe.h not postgres.h.
regards, tom lane