Thread: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
...
... I am really astonished that I could not find anyone else who had this
problem. Am I doing something horridly wrong?
What can I do? I try ./configure'ing PHP, but it tells me:
gcc -o conftest -g -O2 -I/usr/pkg/include -L/usr/pkg/lib
-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
-lm -lcrypt 1>&5
Shared object "libpq.so.2" not found
Complete debug.log installed.
PLEASE help...
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
Forgot the debug.log. It is attached. Also, below:
CONFIGURE: './configure' '--with-apache=../apache_1.3.27' '--with-pgsql=/usr/local/pgsql/'
CC: gcc
CFLAGS: -g -O2
CPPFLAGS: -I/usr/pkg/include
CXX:
CXXFLAGS:
INCLUDES: -I$(top_builddir)/Zend -I/usr/local/pgsql//include
LDFLAGS: -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib
LIBS: -lpq -lcrypt -lm -lcrypt
DLIBS:
SAPI: apache
PHP_RPATHS: /usr/local/pgsql//lib
uname -a: NetBSD fortitude 1.6 NetBSD 1.6 (fortitude) #0: Tue Dec 31 21:36:31 EST 2002
root@fortitude:/usr/src/sys/arch/macppc/compile/fortitudemacppc
gcc -o conftest -g -O2 -I/usr/pkg/include -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c
-lpq-lcrypt -lm -lcrypt 1>&5
Shared object "libpq.so.2" not found
On Mon, 3 Feb 2003, Jessica Blank wrote:
> The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
> expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
> ...
>
> ... I am really astonished that I could not find anyone else who had this
> problem. Am I doing something horridly wrong?
>
> What can I do? I try ./configure'ing PHP, but it tells me:
> gcc -o conftest -g -O2 -I/usr/pkg/include -L/usr/pkg/lib
> -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
> -lm -lcrypt 1>&5
> Shared object "libpq.so.2" not found
>
> Complete debug.log installed.
>
> PLEASE help...
>
> --Jessica
>
> --
> Jessica L. Blank, Systems Administrator & Programmer
>
> www.starchefs.com
> 9 East 19th St., 9th Floor / New York, NY 10003
> Jessica@StarChefs.com - (973) 485-0684
> Pager (917) 675-6618
>
>
> Help Wanted. Help Found.
> www.helpwantedhelpfound.com, a division of StarChefs
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
Attachment
Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
From
"John Chapman"
Date:
> The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP) > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3 > ... > > ... I am really astonished that I could not find anyone else who had > this problem. Am I doing something horridly wrong? I don't know the answer. However, I do not agree with your assertion above. Note the following: root@db:/usr/local/apache/htdocs# psql -V psql (PostgreSQL) 7.3.1 contains support for command-line editing root@db:/usr/local/apache/htdocs# telnet localhost 80 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. HEAD / HTTP/1.0 HTTP/1.1 200 OK Date: Tue, 04 Feb 2003 03:20:20 GMT Server: Apache/1.3.27 (Unix) PHP/4.3.0 Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT ETag: "20cef-0-3e39996b" Accept-Ranges: bytes Content-Length: 0 Connection: close Content-Type: text/html Connection closed by foreign host. *********************************** John Chapman CNI Consulting johnc@cniconsulting.com www.cniemail.com 817-774-0369
I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy
of PostgreSQL 7.3.1. However, two questions:
1) How can I do the same?
2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD
A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or
wherever... A mediocre and kluge-y solution at best. (So everyone
installing PostgreSQL 7.3.x with PHP for the first time is required to
FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of
libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're
all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL
Server. ;) )
Can you show me the output of 'ls' on your PostgreSQL libs directory
please?
--Jessica
On Mon, 3 Feb 2003, John Chapman wrote:
>
>
> > The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
> > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
> > ...
> >
> > ... I am really astonished that I could not find anyone else who had
> > this problem. Am I doing something horridly wrong?
>
> I don't know the answer. However, I do not agree with your assertion
> above. Note the following:
>
>
> root@db:/usr/local/apache/htdocs# psql -V
> psql (PostgreSQL) 7.3.1
> contains support for command-line editing
> root@db:/usr/local/apache/htdocs# telnet localhost 80
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> HEAD / HTTP/1.0
>
> HTTP/1.1 200 OK
> Date: Tue, 04 Feb 2003 03:20:20 GMT
> Server: Apache/1.3.27 (Unix) PHP/4.3.0
> Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT
> ETag: "20cef-0-3e39996b"
> Accept-Ranges: bytes
> Content-Length: 0
> Connection: close
> Content-Type: text/html
>
> Connection closed by foreign host.
>
>
>
> ***********************************
>
> John Chapman
> CNI Consulting
> johnc@cniconsulting.com
> www.cniemail.com
> 817-774-0369
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
I had this problem when I upgraded from 7.3.0 to 7.3.1. I use RedHat 8.0. I do not have libpq.so.2 on the system. I used the following command: ln /usr/lib/libpg.so.3 /usr/lib/libpg.so.2 -s Restarted Apache, and everything worked fine. Tim. Jessica Blank wrote: >I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy >of PostgreSQL 7.3.1. However, two questions: > >1) How can I do the same? >2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD >A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or >wherever... A mediocre and kluge-y solution at best. (So everyone >installing PostgreSQL 7.3.x with PHP for the first time is required to >FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of >libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're >all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL >Server. ;) ) > >Can you show me the output of 'ls' on your PostgreSQL libs directory >please? > >--Jessica > >On Mon, 3 Feb 2003, John Chapman wrote: > > > >> >> >>>The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP) >>>expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3 >>>... >>> >>>... I am really astonished that I could not find anyone else who had >>>this problem. Am I doing something horridly wrong? >>> >>> >>I don't know the answer. However, I do not agree with your assertion >>above. Note the following: >> >> >>root@db:/usr/local/apache/htdocs# psql -V >>psql (PostgreSQL) 7.3.1 >>contains support for command-line editing >>root@db:/usr/local/apache/htdocs# telnet localhost 80 >>Trying 127.0.0.1... >>Connected to localhost. >>Escape character is '^]'. >>HEAD / HTTP/1.0 >> >>HTTP/1.1 200 OK >>Date: Tue, 04 Feb 2003 03:20:20 GMT >>Server: Apache/1.3.27 (Unix) PHP/4.3.0 >>Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT >>ETag: "20cef-0-3e39996b" >>Accept-Ranges: bytes >>Content-Length: 0 >>Connection: close >>Content-Type: text/html >> >>Connection closed by foreign host. >> >> >> >>*********************************** >> >>John Chapman >>CNI Consulting >>johnc@cniconsulting.com >>www.cniemail.com >>817-774-0369 >> >>---------------------------(end of broadcast)--------------------------- >>TIP 3: if posting/reading through Usenet, please send an appropriate >>subscribe-nomail command to majordomo@postgresql.org so that your >>message can get through to the mailing list cleanly >> >> >> > > > --Jessica > > -- > Jessica L. Blank, Systems Administrator & Programmer > > www.starchefs.com > 9 East 19th St., 9th Floor / New York, NY 10003 > Jessica@StarChefs.com - (973) 485-0684 > Pager (917) 675-6618 > > > Help Wanted. Help Found. > www.helpwantedhelpfound.com, a division of StarChefs > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > > >
So this is safe?
...Shouldn't PostgreSQL-latest work *OUT OF THE BOX* with PHP-latest (and
ideally several previous versions as well)??? If all that's needed for a
fix is a symlink, shouldn't the symlink be made by the install process
itself?
On Mon, 3 Feb 2003, Timothy Brier wrote:
> I had this problem when I upgraded from 7.3.0 to 7.3.1.
> I use RedHat 8.0. I do not have libpq.so.2 on the system.
>
> I used the following command:
>
> ln /usr/lib/libpg.so.3 /usr/lib/libpg.so.2 -s
>
> Restarted Apache, and everything worked fine.
>
>
> Tim.
>
>
> Jessica Blank wrote:
>
> >I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy
> >of PostgreSQL 7.3.1. However, two questions:
> >
> >1) How can I do the same?
> >2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD
> >A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or
> >wherever... A mediocre and kluge-y solution at best. (So everyone
> >installing PostgreSQL 7.3.x with PHP for the first time is required to
> >FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of
> >libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're
> >all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL
> >Server. ;) )
> >
> >Can you show me the output of 'ls' on your PostgreSQL libs directory
> >please?
> >
> >--Jessica
> >
> >On Mon, 3 Feb 2003, John Chapman wrote:
> >
> >
> >
> >>
> >>
> >>>The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
> >>>expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
> >>>...
> >>>
> >>>... I am really astonished that I could not find anyone else who had
> >>>this problem. Am I doing something horridly wrong?
> >>>
> >>>
> >>I don't know the answer. However, I do not agree with your assertion
> >>above. Note the following:
> >>
> >>
> >>root@db:/usr/local/apache/htdocs# psql -V
> >>psql (PostgreSQL) 7.3.1
> >>contains support for command-line editing
> >>root@db:/usr/local/apache/htdocs# telnet localhost 80
> >>Trying 127.0.0.1...
> >>Connected to localhost.
> >>Escape character is '^]'.
> >>HEAD / HTTP/1.0
> >>
> >>HTTP/1.1 200 OK
> >>Date: Tue, 04 Feb 2003 03:20:20 GMT
> >>Server: Apache/1.3.27 (Unix) PHP/4.3.0
> >>Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT
> >>ETag: "20cef-0-3e39996b"
> >>Accept-Ranges: bytes
> >>Content-Length: 0
> >>Connection: close
> >>Content-Type: text/html
> >>
> >>Connection closed by foreign host.
> >>
> >>
> >>
> >>***********************************
> >>
> >>John Chapman
> >>CNI Consulting
> >>johnc@cniconsulting.com
> >>www.cniemail.com
> >>817-774-0369
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 3: if posting/reading through Usenet, please send an appropriate
> >>subscribe-nomail command to majordomo@postgresql.org so that your
> >>message can get through to the mailing list cleanly
> >>
> >>
> >>
> >
> >
> > --Jessica
> >
> > --
> > Jessica L. Blank, Systems Administrator & Programmer
> >
> > www.starchefs.com
> > 9 East 19th St., 9th Floor / New York, NY 10003
> > Jessica@StarChefs.com - (973) 485-0684
> > Pager (917) 675-6618
> >
> >
> > Help Wanted. Help Found.
> > www.helpwantedhelpfound.com, a division of StarChefs
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
> >
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
On Mon, 3 Feb 2003, Jessica Blank wrote: > I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy > of PostgreSQL 7.3.1. However, two questions: > > 1) How can I do the same? > 2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD > A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or > wherever... A mediocre and kluge-y solution at best. (So everyone > installing PostgreSQL 7.3.x with PHP for the first time is required to > FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of > libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're > all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL > Server. ;) ) > > Can you show me the output of 'ls' on your PostgreSQL libs directory > please? > > --Jessica > [jross@rand.openvistas.net] $ ls -al /usr/local/pgsql/lib/ total 7364 drwxr-xr-x 2 root wheel 1024 Jan 24 21:12 . drwxr-xr-x 8 root wheel 512 Jan 24 21:11 .. -rwxr-xr-x 1 root wheel 8430 Jan 24 21:11 ascii_and_mic.so -rwxr-xr-x 1 root wheel 13640 Jan 24 21:11 cyrillic_and_mic.so -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 euc_cn_and_mic.so -rwxr-xr-x 1 root wheel 8682 Jan 24 21:11 euc_jp_and_sjis.so -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 euc_kr_and_mic.so -rwxr-xr-x 1 root wheel 8728 Jan 24 21:11 euc_tw_and_big5.so -rwxr-xr-x 1 root wheel 8706 Jan 24 21:11 latin2_and_win1250.so -rwxr-xr-x 1 root wheel 8686 Jan 24 21:11 latin_and_mic.so -rw-r--r-- 1 root wheel 42336 Jan 24 21:11 libecpg.a lrwxr-xr-x 1 root wheel 16 Jan 24 21:11 libecpg.so -> libecpg.so.3.4.1 lrwxr-xr-x 1 root wheel 16 Jan 24 21:11 libecpg.so.3 -> libecpg.so.3.4.1 -rwxr-xr-x 1 root wheel 37950 Jan 24 21:11 libecpg.so.3.4.1 -rw-r--r-- 1 root wheel 92182 Jan 24 21:11 libpq.a lrwxr-xr-x 1 root wheel 12 Jan 24 21:11 libpq.so -> libpq.so.3.0 lrwxr-xr-x 1 root wheel 12 Jan 24 21:11 libpq.so.3 -> libpq.so.3.0 -rwxr-xr-x 1 root wheel 77866 Jan 24 21:11 libpq.so.3.0 -rwxr-xr-x 1 root wheel 88277 Jan 24 21:12 plpgsql.so -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 utf8_and_ascii.so -rwxr-xr-x 1 root wheel 225518 Jan 24 21:11 utf8_and_big5.so -rwxr-xr-x 1 root wheel 12782 Jan 24 21:11 utf8_and_cyrillic.so -rwxr-xr-x 1 root wheel 127222 Jan 24 21:11 utf8_and_euc_cn.so -rwxr-xr-x 1 root wheel 217334 Jan 24 21:11 utf8_and_euc_jp.so -rwxr-xr-x 1 root wheel 139510 Jan 24 21:11 utf8_and_euc_kr.so -rwxr-xr-x 1 root wheel 336118 Jan 24 21:11 utf8_and_euc_tw.so -rwxr-xr-x 1 root wheel 1020154 Jan 24 21:11 utf8_and_gb18030.so -rwxr-xr-x 1 root wheel 356586 Jan 24 21:11 utf8_and_gbk.so -rwxr-xr-x 1 root wheel 33018 Jan 24 21:11 utf8_and_iso8859.so -rwxr-xr-x 1 root wheel 8450 Jan 24 21:11 utf8_and_iso8859_1.so -rwxr-xr-x 1 root wheel 278770 Jan 24 21:11 utf8_and_johab.so -rwxr-xr-x 1 root wheel 127214 Jan 24 21:11 utf8_and_sjis.so -rwxr-xr-x 1 root wheel 8430 Jan 24 21:11 utf8_and_tcvn.so -rwxr-xr-x 1 root wheel 278762 Jan 24 21:11 utf8_and_uhc.so -rwxr-xr-x 1 root wheel 8438 Jan 24 21:11 utf8_and_win1250.so -rwxr-xr-x 1 root wheel 8438 Jan 24 21:11 utf8_and_win1256.so -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 utf8_and_win874.so [jross@rand.openvistas.net] $ php -v PHP 4.3.0 (cgi), Copyright (c) 1997-2002 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies [jross@rand.openvistas.net] $ uname -a OpenBSD rand.openvistas.net 3.2 GENERIC#0 i386 This is a fresh install, compiling both from source. Working great in CGI versions, since I don't run Apache. -- Jeff Ross Open Vistas Networking, Inc. http://www.openvistas.net
> I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR > copy > of PostgreSQL 7.3.1. However, two questions: > > 1) How can I do the same? Compile and install PostgreSQL 7.3.1 ldconfig -m /usr/local/pgsql/lib (or whatever) (If you're on FreeBSD. If not, look up the right command for your OS) compile and install PHP :-) > 2) Were you previously using PostgreSQL 7.3.0? If so, you most likely > HAD > A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or > wherever... A mediocre and kluge-y solution at best. (So everyone > installing PostgreSQL 7.3.x with PHP for the first time is required to > FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions > of > libpq.so? That would be a horrendous band-aid-ish solution. C'mon, > we're > all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL > Server. ;) ) If the older lib is getting in your way - remove it.. I'm almost positive that in the 7.3.1 install docs was very clear about having to recompile everything that linked to libpq. Good luck! -Mitch
That is quite bizarre. Do you by any chance have record of the parameters you used for ./configure on PHP and on PostgreSQL? On Mon, 3 Feb 2003, Jeff Ross wrote: > On Mon, 3 Feb 2003, Jessica Blank wrote: > > > I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy > > of PostgreSQL 7.3.1. However, two questions: > > > > 1) How can I do the same? > > 2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD > > A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or > > wherever... A mediocre and kluge-y solution at best. (So everyone > > installing PostgreSQL 7.3.x with PHP for the first time is required to > > FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of > > libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're > > all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL > > Server. ;) ) > > > > Can you show me the output of 'ls' on your PostgreSQL libs directory > > please? > > > > --Jessica > > > [jross@rand.openvistas.net] $ ls -al /usr/local/pgsql/lib/ > total 7364 > drwxr-xr-x 2 root wheel 1024 Jan 24 21:12 . > drwxr-xr-x 8 root wheel 512 Jan 24 21:11 .. > -rwxr-xr-x 1 root wheel 8430 Jan 24 21:11 ascii_and_mic.so > -rwxr-xr-x 1 root wheel 13640 Jan 24 21:11 cyrillic_and_mic.so > -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 euc_cn_and_mic.so > -rwxr-xr-x 1 root wheel 8682 Jan 24 21:11 euc_jp_and_sjis.so > -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 euc_kr_and_mic.so > -rwxr-xr-x 1 root wheel 8728 Jan 24 21:11 euc_tw_and_big5.so > -rwxr-xr-x 1 root wheel 8706 Jan 24 21:11 latin2_and_win1250.so > -rwxr-xr-x 1 root wheel 8686 Jan 24 21:11 latin_and_mic.so > -rw-r--r-- 1 root wheel 42336 Jan 24 21:11 libecpg.a > lrwxr-xr-x 1 root wheel 16 Jan 24 21:11 libecpg.so -> > libecpg.so.3.4.1 > lrwxr-xr-x 1 root wheel 16 Jan 24 21:11 libecpg.so.3 -> > libecpg.so.3.4.1 > -rwxr-xr-x 1 root wheel 37950 Jan 24 21:11 libecpg.so.3.4.1 > -rw-r--r-- 1 root wheel 92182 Jan 24 21:11 libpq.a > lrwxr-xr-x 1 root wheel 12 Jan 24 21:11 libpq.so -> libpq.so.3.0 > lrwxr-xr-x 1 root wheel 12 Jan 24 21:11 libpq.so.3 -> libpq.so.3.0 > -rwxr-xr-x 1 root wheel 77866 Jan 24 21:11 libpq.so.3.0 > -rwxr-xr-x 1 root wheel 88277 Jan 24 21:12 plpgsql.so > -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 utf8_and_ascii.so > -rwxr-xr-x 1 root wheel 225518 Jan 24 21:11 utf8_and_big5.so > -rwxr-xr-x 1 root wheel 12782 Jan 24 21:11 utf8_and_cyrillic.so > -rwxr-xr-x 1 root wheel 127222 Jan 24 21:11 utf8_and_euc_cn.so > -rwxr-xr-x 1 root wheel 217334 Jan 24 21:11 utf8_and_euc_jp.so > -rwxr-xr-x 1 root wheel 139510 Jan 24 21:11 utf8_and_euc_kr.so > -rwxr-xr-x 1 root wheel 336118 Jan 24 21:11 utf8_and_euc_tw.so > -rwxr-xr-x 1 root wheel 1020154 Jan 24 21:11 utf8_and_gb18030.so > -rwxr-xr-x 1 root wheel 356586 Jan 24 21:11 utf8_and_gbk.so > -rwxr-xr-x 1 root wheel 33018 Jan 24 21:11 utf8_and_iso8859.so > -rwxr-xr-x 1 root wheel 8450 Jan 24 21:11 utf8_and_iso8859_1.so > -rwxr-xr-x 1 root wheel 278770 Jan 24 21:11 utf8_and_johab.so > -rwxr-xr-x 1 root wheel 127214 Jan 24 21:11 utf8_and_sjis.so > -rwxr-xr-x 1 root wheel 8430 Jan 24 21:11 utf8_and_tcvn.so > -rwxr-xr-x 1 root wheel 278762 Jan 24 21:11 utf8_and_uhc.so > -rwxr-xr-x 1 root wheel 8438 Jan 24 21:11 utf8_and_win1250.so > -rwxr-xr-x 1 root wheel 8438 Jan 24 21:11 utf8_and_win1256.so > -rwxr-xr-x 1 root wheel 8434 Jan 24 21:11 utf8_and_win874.so > > > [jross@rand.openvistas.net] $ php -v > PHP 4.3.0 (cgi), Copyright (c) 1997-2002 The PHP Group > Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies > > [jross@rand.openvistas.net] $ uname -a > OpenBSD rand.openvistas.net 3.2 GENERIC#0 i386 > > This is a fresh install, compiling both from source. Working great in CGI > versions, since I don't run Apache. > > > -- > Jeff Ross > Open Vistas Networking, Inc. > http://www.openvistas.net > > > --Jessica -- Jessica L. Blank, Systems Administrator & Programmer www.starchefs.com 9 East 19th St., 9th Floor / New York, NY 10003 Jessica@StarChefs.com - (973) 485-0684 Pager (917) 675-6618 Help Wanted. Help Found. www.helpwantedhelpfound.com, a division of StarChefs
I just installed postgres 7.3.1 and php 4.3.0 on a fresh server a couple of days ago and didn't get your error... I haven't used it much, but "php -i" returns: pgsql PostgreSQL Support => enabled PostgreSQL(libpq) Version => 7.3.1 Multibyte character support => enabled SSL support => disabled Active Persistent Links => 0 Active Links => 0 and I do not have a libpq.so.2 (I have .3) On Mon, 3 Feb 2003, Jessica Blank wrote: > I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy > of PostgreSQL 7.3.1. However, two questions: > > 1) How can I do the same? > 2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD > A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or > wherever... A mediocre and kluge-y solution at best. (So everyone > installing PostgreSQL 7.3.x with PHP for the first time is required to > FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of > libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're > all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL > Server. ;) ) > > Can you show me the output of 'ls' on your PostgreSQL libs directory > please? > > --Jessica > > On Mon, 3 Feb 2003, John Chapman wrote: > > > > > > > > The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP) > > > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3 > > > ... > > > > > > ... I am really astonished that I could not find anyone else who had > > > this problem. Am I doing something horridly wrong? > > > > I don't know the answer. However, I do not agree with your assertion > > above. Note the following: > > > > > > root@db:/usr/local/apache/htdocs# psql -V > > psql (PostgreSQL) 7.3.1 > > contains support for command-line editing > > root@db:/usr/local/apache/htdocs# telnet localhost 80 > > Trying 127.0.0.1... > > Connected to localhost. > > Escape character is '^]'. > > HEAD / HTTP/1.0 > > > > HTTP/1.1 200 OK > > Date: Tue, 04 Feb 2003 03:20:20 GMT > > Server: Apache/1.3.27 (Unix) PHP/4.3.0 > > Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT > > ETag: "20cef-0-3e39996b" > > Accept-Ranges: bytes > > Content-Length: 0 > > Connection: close > > Content-Type: text/html > > > > Connection closed by foreign host. > > > > > > > > *********************************** > > > > John Chapman > > CNI Consulting > > johnc@cniconsulting.com > > www.cniemail.com > > 817-774-0369 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > > --Jessica > > -- > Jessica L. Blank, Systems Administrator & Programmer > > www.starchefs.com > 9 East 19th St., 9th Floor / New York, NY 10003 > Jessica@StarChefs.com - (973) 485-0684 > Pager (917) 675-6618 > > > Help Wanted. Help Found. > www.helpwantedhelpfound.com, a division of StarChefs > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
That's a pretty bad idea.. You need to recompile everything that links to libpq (as stated in the 7.3.1 docs). They wouldn't have changed the version number if they hadn't changed the API... > I had this problem when I upgraded from 7.3.0 to 7.3.1. I use RedHat > 8.0. I do not have libpq.so.2 on the system. > > I used the following command: > > ln /usr/lib/libpg.so.3 /usr/lib/libpg.so.2 -s > > Restarted Apache, and everything worked fine. > > > Tim. > -Mitch
Quite odd. Maybe, as someone suggested, it is an issue of library path...
am looking into that now.
On Mon, 3 Feb 2003, Philip Hallstrom wrote:
> I just installed postgres 7.3.1 and php 4.3.0 on a fresh server a couple
> of days ago and didn't get your error... I haven't used it much, but "php
> -i" returns:
>
> pgsql
>
> PostgreSQL Support => enabled
> PostgreSQL(libpq) Version => 7.3.1
> Multibyte character support => enabled
> SSL support => disabled
> Active Persistent Links => 0
> Active Links => 0
>
>
> and I do not have a libpq.so.2 (I have .3)
>
> On Mon, 3 Feb 2003, Jessica Blank wrote:
>
> > I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy
> > of PostgreSQL 7.3.1. However, two questions:
> >
> > 1) How can I do the same?
> > 2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD
> > A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or
> > wherever... A mediocre and kluge-y solution at best. (So everyone
> > installing PostgreSQL 7.3.x with PHP for the first time is required to
> > FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of
> > libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're
> > all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL
> > Server. ;) )
> >
> > Can you show me the output of 'ls' on your PostgreSQL libs directory
> > please?
> >
> > --Jessica
> >
> > On Mon, 3 Feb 2003, John Chapman wrote:
> >
> > >
> > >
> > > > The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
> > > > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
> > > > ...
> > > >
> > > > ... I am really astonished that I could not find anyone else who had
> > > > this problem. Am I doing something horridly wrong?
> > >
> > > I don't know the answer. However, I do not agree with your assertion
> > > above. Note the following:
> > >
> > >
> > > root@db:/usr/local/apache/htdocs# psql -V
> > > psql (PostgreSQL) 7.3.1
> > > contains support for command-line editing
> > > root@db:/usr/local/apache/htdocs# telnet localhost 80
> > > Trying 127.0.0.1...
> > > Connected to localhost.
> > > Escape character is '^]'.
> > > HEAD / HTTP/1.0
> > >
> > > HTTP/1.1 200 OK
> > > Date: Tue, 04 Feb 2003 03:20:20 GMT
> > > Server: Apache/1.3.27 (Unix) PHP/4.3.0
> > > Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT
> > > ETag: "20cef-0-3e39996b"
> > > Accept-Ranges: bytes
> > > Content-Length: 0
> > > Connection: close
> > > Content-Type: text/html
> > >
> > > Connection closed by foreign host.
> > >
> > >
> > >
> > > ***********************************
> > >
> > > John Chapman
> > > CNI Consulting
> > > johnc@cniconsulting.com
> > > www.cniemail.com
> > > 817-774-0369
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> > >
> >
> >
> > --Jessica
> >
> > --
> > Jessica L. Blank, Systems Administrator & Programmer
> >
> > www.starchefs.com
> > 9 East 19th St., 9th Floor / New York, NY 10003
> > Jessica@StarChefs.com - (973) 485-0684
> > Pager (917) 675-6618
> >
> >
> > Help Wanted. Help Found.
> > www.helpwantedhelpfound.com, a division of StarChefs
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
On Monday 03 February 2003 22:12, Jessica Blank wrote: > The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP) > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3 > ... Recompile PHP, and it will work. If you got it as an RPM, get the source (src.rpm) RPM and issue a 'rpmbuild --rebuild php....src.rpm' (substitute the version and other information for the dots above...). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
> I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR > copy of PostgreSQL 7.3.1. However, two questions: It illustrates that they are compatible. > > 1) How can I do the same? I don't know. > 2) Were you previously using PostgreSQL 7.3.0? No. If so, you most likely > HAD A COPY of libpq.so.2 still floating about in > /usr/local/postgres/lib or wherever... A mediocre and kluge-y solution > at best. (So everyone installing PostgreSQL 7.3.x with PHP for the > first time is required to FIRST install 7.3.0, THEN install 7.3.1 atop > it, to get both versions of libpq.so? That would be a horrendous > band-aid-ish solution. C'mon, we're all above that sort of rubbish. > This is PostgreSQL, not Microsoft SQL Server. ;) ) > You are jumping to assumptions here. Probably in your troubleshooting as well. However, this was a fresh install of Slackware 8.1, fresh install of apache, fresh install of php. I merely followed the documentation. John Chapman CNI Consulting johnc@cniconsulting.com www.cniemail.com 817-774-0369
I am using NetBSD 1.6 on a PowerMac. ;)
And I did compile PHP -after- Postgres. :/
On Mon, 3 Feb 2003, Lamar Owen wrote:
> On Monday 03 February 2003 22:12, Jessica Blank wrote:
> > The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
> > expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
> > ...
>
> Recompile PHP, and it will work. If you got it as an RPM, get the source
> (src.rpm) RPM and issue a 'rpmbuild --rebuild php....src.rpm' (substitute the
> version and other information for the dots above...).
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
>
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
Hi Jessica, Timothy's solution of creating a symlink from the expected file to the actual file should work for you. # ln -s [the path to the libpg.so.3 file] [the path to where the libpg.so.3 is, but with libpg.so.2 instead] i.e. # ln -s /usr/local/lib/libpg.so.3 /usr/local/lib/libpg.so.2 or # ln -s /usr/lib/libpg.so.3 /usr/lib/libpg.so.2 or # ln -s /opt/pgsql/lib/libpg.so.3 /opt/pgsql/lib/libpg.so.2 You get the idea. :-) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
On Monday 03 February 2003 22:59, Jessica Blank wrote: > I am using NetBSD 1.6 on a PowerMac. ;) > > And I did compile PHP -after- Postgres. :/ Are you sure it picked up the right headers? Is there an older PostgreSQL on the system? Are you absolutely sure that you compiled PHP against PostgreSQL 7.3.1? The fact is that others aren't able to reproduce the problem; further it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1 the version number was bumped to .3. So at some point in your PHP build the linker linked against the development headers/libs for .2 instead of .3. Something is telling the PHP build to look for the older version. As no one else can reproduce it, it must be something unique to your installation, at some point. Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more than one place. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Thank you! Yes, I do know how to symlink ;) I have been using Unix for
many many years. I am just continually amazed at how often I try using
$MAJOR_OSS/FS_SOFTWARE_PACKAGE_X together with
$MAJOR_OSS/FS_SOFTWARE_PACKAGE_Y, and they puke, right out of the box. And
then I need to figure out why.
Of course, you don't have this problem if you just use Red Hat for x86
like the rest of everyone, but ... why? Anyhow. End rant mode.
On Tue, 4 Feb 2003, Justin Clift wrote:
> Hi Jessica,
>
> Timothy's solution of creating a symlink from the expected file to the
> actual file should work for you.
>
> # ln -s [the path to the libpg.so.3 file] [the path to where the
> libpg.so.3 is, but with libpg.so.2 instead]
>
> i.e.
> # ln -s /usr/local/lib/libpg.so.3 /usr/local/lib/libpg.so.2
> or
> # ln -s /usr/lib/libpg.so.3 /usr/lib/libpg.so.2
> or
> # ln -s /opt/pgsql/lib/libpg.so.3 /opt/pgsql/lib/libpg.so.2
>
> You get the idea.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
>
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
On Mon, 3 Feb 2003, Lamar Owen wrote:
> On Monday 03 February 2003 22:59, Jessica Blank wrote:
> > I am using NetBSD 1.6 on a PowerMac. ;)
> >
> > And I did compile PHP -after- Postgres. :/
>
> Are you sure it picked up the right headers? Is there an older PostgreSQL on
> the system? Are you absolutely sure that you compiled PHP against PostgreSQL
> 7.3.1? The fact is that others aren't able to reproduce the problem; further
> it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1
> the version number was bumped to .3. So at some point in your PHP build the
> linker linked against the development headers/libs for .2 instead of .3.
> Something is telling the PHP build to look for the older version.
>
Shouldn't be. I think this is the only version of PostgreSQL on the
system...
> As no one else can reproduce it, it must be something unique to your
> installation, at some point.
>
> Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more
> than one place.
Glug.
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
>
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
Inexplicably, it works now, out of nowhere. >sigh< Go figure.
My thanks to those who responded to my problem so quickly! Y'all are
wonderful. I just wish modern software weren't so insanely complex...
On Mon, 3 Feb 2003, Lamar Owen wrote:
> On Monday 03 February 2003 22:59, Jessica Blank wrote:
> > I am using NetBSD 1.6 on a PowerMac. ;)
> >
> > And I did compile PHP -after- Postgres. :/
>
> Are you sure it picked up the right headers? Is there an older PostgreSQL on
> the system? Are you absolutely sure that you compiled PHP against PostgreSQL
> 7.3.1? The fact is that others aren't able to reproduce the problem; further
> it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1
> the version number was bumped to .3. So at some point in your PHP build the
> linker linked against the development headers/libs for .2 instead of .3.
> Something is telling the PHP build to look for the older version.
>
> As no one else can reproduce it, it must be something unique to your
> installation, at some point.
>
> Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more
> than one place.
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
>
>
--Jessica
--
Jessica L. Blank, Systems Administrator & Programmer
www.starchefs.com
9 East 19th St., 9th Floor / New York, NY 10003
Jessica@StarChefs.com - (973) 485-0684
Pager (917) 675-6618
Help Wanted. Help Found.
www.helpwantedhelpfound.com, a division of StarChefs
In article <Pine.GSO.4.05.10302032225270.14859-100000@knife.starchefs.com>: > I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy > of PostgreSQL 7.3.1. However, two questions: > > 1) How can I do the same? I do not run php, but how about rebuilding it from source? That will probably pick up the new library and link it in.
Hi Jessica-- What I would do is-- cd /path/to/php/dir ./configure --with-pgsql=/path/to/postresql/source make make install Then restart apache. It may be finding the old PgSQL libs, headers, etc. Best Wishes, Chris Jessica Blank wrote: >Quite odd. Maybe, as someone suggested, it is an issue of library path... >am looking into that now. > >On Mon, 3 Feb 2003, Philip Hallstrom wrote: > > > >>I just installed postgres 7.3.1 and php 4.3.0 on a fresh server a couple >>of days ago and didn't get your error... I haven't used it much, but "php >>-i" returns: >> >>pgsql >> >>PostgreSQL Support => enabled >>PostgreSQL(libpq) Version => 7.3.1 >>Multibyte character support => enabled >>SSL support => disabled >>Active Persistent Links => 0 >>Active Links => 0 >> >> >>and I do not have a libpq.so.2 (I have .3) >> >>On Mon, 3 Feb 2003, Jessica Blank wrote: >> >> >> >>>I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy >>>of PostgreSQL 7.3.1. However, two questions: >>> >>>1) How can I do the same? >>>2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD >>>A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or >>>wherever... A mediocre and kluge-y solution at best. (So everyone >>>installing PostgreSQL 7.3.x with PHP for the first time is required to >>>FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of >>>libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're >>>all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL >>>Server. ;) ) >>> >>>Can you show me the output of 'ls' on your PostgreSQL libs directory >>>please? >>> >>>--Jessica >>> >>>On Mon, 3 Feb 2003, John Chapman wrote: >>> >>> >>> >>>> >>>> >>>>>The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP) >>>>>expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3 >>>>>... >>>>> >>>>>... I am really astonished that I could not find anyone else who had >>>>>this problem. Am I doing something horridly wrong? >>>>> >>>>> >>>>I don't know the answer. However, I do not agree with your assertion >>>>above. Note the following: >>>> >>>> >>>>root@db:/usr/local/apache/htdocs# psql -V >>>>psql (PostgreSQL) 7.3.1 >>>>contains support for command-line editing >>>>root@db:/usr/local/apache/htdocs# telnet localhost 80 >>>>Trying 127.0.0.1... >>>>Connected to localhost. >>>>Escape character is '^]'. >>>>HEAD / HTTP/1.0 >>>> >>>>HTTP/1.1 200 OK >>>>Date: Tue, 04 Feb 2003 03:20:20 GMT >>>>Server: Apache/1.3.27 (Unix) PHP/4.3.0 >>>>Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT >>>>ETag: "20cef-0-3e39996b" >>>>Accept-Ranges: bytes >>>>Content-Length: 0 >>>>Connection: close >>>>Content-Type: text/html >>>> >>>>Connection closed by foreign host. >>>> >>>> >>>> >>>>*********************************** >>>> >>>>John Chapman >>>>CNI Consulting >>>>johnc@cniconsulting.com >>>>www.cniemail.com >>>>817-774-0369 >>>> >>>>---------------------------(end of broadcast)--------------------------- >>>>TIP 3: if posting/reading through Usenet, please send an appropriate >>>>subscribe-nomail command to majordomo@postgresql.org so that your >>>>message can get through to the mailing list cleanly >>>> >>>> >>>> >>> --Jessica >>> >>> -- >>> Jessica L. Blank, Systems Administrator & Programmer >>> >>> www.starchefs.com >>> 9 East 19th St., 9th Floor / New York, NY 10003 >>> Jessica@StarChefs.com - (973) 485-0684 >>> Pager (917) 675-6618 >>> >>> >>> Help Wanted. Help Found. >>> www.helpwantedhelpfound.com, a division of StarChefs >>> >>> >>> >>>---------------------------(end of broadcast)--------------------------- >>>TIP 4: Don't 'kill -9' the postmaster >>> >>> >>> >> >> > > > --Jessica > > -- > Jessica L. Blank, Systems Administrator & Programmer > > www.starchefs.com > 9 East 19th St., 9th Floor / New York, NY 10003 > Jessica@StarChefs.com - (973) 485-0684 > Pager (917) 675-6618 > > > Help Wanted. Help Found. > www.helpwantedhelpfound.com, a division of StarChefs > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly > > > >
On Mon, 2003-02-03 at 23:00, Justin Clift wrote: > Timothy's solution of creating a symlink from the expected file to the > actual file should work for you. That doesn't make it any less of a bad idea: the .so version number was bumped for a reason (namely, that libpq.so.2 and libpq.so.3 aren't binary compatible). Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
On 4 Feb 2003, Neil Conway wrote: > On Mon, 2003-02-03 at 23:00, Justin Clift wrote: > > Timothy's solution of creating a symlink from the expected file to the > > actual file should work for you. > > That doesn't make it any less of a bad idea: the .so version number was > bumped for a reason (namely, that libpq.so.2 and libpq.so.3 aren't > binary compatible). > > Cheers, > > Neil But to complicate matters; the libpq.so.2 from 7.3.0 _is_ compatible with libpq.so.3 isn't it? I thought the version number bump was an oversight in 7.3. -- Nigel J. Andrews