Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 - Mailing list pgsql-general

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