Re: Segmentation Fault V 9.1.5 - Mailing list pgsql-bugs

On 30 August 2012 20:29, Jeff Lake <admin@michiganwxsystem.com> wrote:
> I have looked at darn near every listing for this bug ..
> "..because curl is loaded before postgresql"  << nope didn't work
> here is my system specs

This must be the worst bug report I've ever seen. I'd give the usual
link to "How to Report Bugs Effectively", but it would probably be
lost on someone who seems to lack even basic manners.

> so whats the fix ???
> or do I need to just delete, forget and reuse MySQL ???

Well, from a little googling I gather that MySQL is also affected by
this PHP bug (I am not 100% sure that this is what you're referring
to):

http://www.logikdev.com/tag/postgresql/

What you don't seem to realise is that this is a mailing list for bugs
in the PostgreSQL server. "pgsql" in this context refers to a
third-party client library for php, and there's no reason to believe
that any of its maintainers are active on this mailing list.

That said, why are you trying to use the "ordering" kludge recommended here?

https://bugs.php.net/bug.php?id=40926&edit=3

It sounds extremely fragile.

Since we apparently now defensively unregister the callbacks
associated with this problem, as of this commit from back in 2008:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4e816286533dd34c10b368487d4079595a3e1418

It seems likely that pgsql.so is still linking to some ancient,
unsupported libpq, even though you don't think that it is. Are you
sure that you're using the libpq distributed with 9.1.5? I don't know
much about php, but for Python, you'd do something like:

[peter@peterlaptop psycopg2]$ ldd _psycopg.so
    linux-vdso.so.1 =>  (0x00007fffbd5ff000)
    libpython2.7.so.1.0 => /lib64/libpython2.7.so.1.0 (0x00007f8753aa4000)
    libpq.so.5 => /home/peter/pgsql/lib/libpq.so.5 (0x00007f875387c000)
    libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8753660000)
    libc.so.6 => /lib64/libc.so.6 (0x00007f87532a9000)
    libdl.so.2 => /lib64/libdl.so.2 (0x00007f87530a4000)
    libutil.so.1 => /lib64/libutil.so.1 (0x00007f8752ea1000)
    libm.so.6 => /lib64/libm.so.6 (0x00007f8752ba6000)
    /lib64/ld-linux-x86-64.so.2 (0x0000003cdc400000)

Is the libpq shared object you see here (but for pgsql.so) the one
that you expect?

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services