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