How to install libpq.so.4.x on Debian 9

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP












0















I try to compil from source PHP5.3.29 on Debian 9. The make command stopped in error at this step



LDFLAGS="-Wl,-rpath=/opt/OpenSSL/openssl-1.0.1u/lib,-rpath=/opt/CURL/curl-7.26.0/lib" make
.../...
(.text+0x5d7e): warning: the use of `tmpnam' is dangerous, better use `mkstemp'
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: /usr/lib/x86_64-linux-gnu/libc-client.a(osdep.o): undefined reference to symbol 'TLS_server_method@@OPENSSL_1_1_0'
//usr/lib/x86_64-linux-gnu/libssl.so.1.1: error adding symbols: DSO missing from command line
collect2: error: ld returned 1 exit status
Makefile:277: recipe for target 'sapi/fpm/php-fpm' failed
make: *** [sapi/fpm/php-fpm] Error 1


Like I compiled old version of OpenSSL and Curl. I suppect libpq.so is not old enough



# ls -l /usr/lib/x86_64-linux-gnu/libpq.so
lrwxrwxrwx 1 root root 12 Aug 9 23:22 /usr/lib/x86_64-linux-gnu/libpq.so -> libpq.so.5.9


I don't know how to find the source of libpq.so.4.x which is a PostgreSQL library.










share|improve this question
























  • Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

    – Stephen Kitt
    Jan 4 at 9:40











  • @Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

    – dubis
    Jan 4 at 9:42












  • The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

    – dubis
    Jan 4 at 10:05






  • 1





    Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

    – Rui F Ribeiro
    Jan 4 at 10:10







  • 1





    @Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

    – Stephen Kitt
    Jan 4 at 10:17















0















I try to compil from source PHP5.3.29 on Debian 9. The make command stopped in error at this step



LDFLAGS="-Wl,-rpath=/opt/OpenSSL/openssl-1.0.1u/lib,-rpath=/opt/CURL/curl-7.26.0/lib" make
.../...
(.text+0x5d7e): warning: the use of `tmpnam' is dangerous, better use `mkstemp'
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: /usr/lib/x86_64-linux-gnu/libc-client.a(osdep.o): undefined reference to symbol 'TLS_server_method@@OPENSSL_1_1_0'
//usr/lib/x86_64-linux-gnu/libssl.so.1.1: error adding symbols: DSO missing from command line
collect2: error: ld returned 1 exit status
Makefile:277: recipe for target 'sapi/fpm/php-fpm' failed
make: *** [sapi/fpm/php-fpm] Error 1


Like I compiled old version of OpenSSL and Curl. I suppect libpq.so is not old enough



# ls -l /usr/lib/x86_64-linux-gnu/libpq.so
lrwxrwxrwx 1 root root 12 Aug 9 23:22 /usr/lib/x86_64-linux-gnu/libpq.so -> libpq.so.5.9


I don't know how to find the source of libpq.so.4.x which is a PostgreSQL library.










share|improve this question
























  • Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

    – Stephen Kitt
    Jan 4 at 9:40











  • @Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

    – dubis
    Jan 4 at 9:42












  • The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

    – dubis
    Jan 4 at 10:05






  • 1





    Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

    – Rui F Ribeiro
    Jan 4 at 10:10







  • 1





    @Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

    – Stephen Kitt
    Jan 4 at 10:17













0












0








0








I try to compil from source PHP5.3.29 on Debian 9. The make command stopped in error at this step



LDFLAGS="-Wl,-rpath=/opt/OpenSSL/openssl-1.0.1u/lib,-rpath=/opt/CURL/curl-7.26.0/lib" make
.../...
(.text+0x5d7e): warning: the use of `tmpnam' is dangerous, better use `mkstemp'
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: /usr/lib/x86_64-linux-gnu/libc-client.a(osdep.o): undefined reference to symbol 'TLS_server_method@@OPENSSL_1_1_0'
//usr/lib/x86_64-linux-gnu/libssl.so.1.1: error adding symbols: DSO missing from command line
collect2: error: ld returned 1 exit status
Makefile:277: recipe for target 'sapi/fpm/php-fpm' failed
make: *** [sapi/fpm/php-fpm] Error 1


Like I compiled old version of OpenSSL and Curl. I suppect libpq.so is not old enough



# ls -l /usr/lib/x86_64-linux-gnu/libpq.so
lrwxrwxrwx 1 root root 12 Aug 9 23:22 /usr/lib/x86_64-linux-gnu/libpq.so -> libpq.so.5.9


I don't know how to find the source of libpq.so.4.x which is a PostgreSQL library.










share|improve this question
















I try to compil from source PHP5.3.29 on Debian 9. The make command stopped in error at this step



LDFLAGS="-Wl,-rpath=/opt/OpenSSL/openssl-1.0.1u/lib,-rpath=/opt/CURL/curl-7.26.0/lib" make
.../...
(.text+0x5d7e): warning: the use of `tmpnam' is dangerous, better use `mkstemp'
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: warning: libssl.so.1.1, needed by /usr/lib/x86_64-linux-gnu/libpq.so, may conflict with libssl.so.1.0.0
/usr/bin/ld: /usr/lib/x86_64-linux-gnu/libc-client.a(osdep.o): undefined reference to symbol 'TLS_server_method@@OPENSSL_1_1_0'
//usr/lib/x86_64-linux-gnu/libssl.so.1.1: error adding symbols: DSO missing from command line
collect2: error: ld returned 1 exit status
Makefile:277: recipe for target 'sapi/fpm/php-fpm' failed
make: *** [sapi/fpm/php-fpm] Error 1


Like I compiled old version of OpenSSL and Curl. I suppect libpq.so is not old enough



# ls -l /usr/lib/x86_64-linux-gnu/libpq.so
lrwxrwxrwx 1 root root 12 Aug 9 23:22 /usr/lib/x86_64-linux-gnu/libpq.so -> libpq.so.5.9


I don't know how to find the source of libpq.so.4.x which is a PostgreSQL library.







compiling postgresql ld






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 4 at 10:03









Rui F Ribeiro

39.5k1479132




39.5k1479132










asked Jan 4 at 9:33









dubisdubis

5231516




5231516












  • Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

    – Stephen Kitt
    Jan 4 at 9:40











  • @Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

    – dubis
    Jan 4 at 9:42












  • The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

    – dubis
    Jan 4 at 10:05






  • 1





    Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

    – Rui F Ribeiro
    Jan 4 at 10:10







  • 1





    @Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

    – Stephen Kitt
    Jan 4 at 10:17

















  • Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

    – Stephen Kitt
    Jan 4 at 9:40











  • @Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

    – dubis
    Jan 4 at 9:42












  • The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

    – dubis
    Jan 4 at 10:05






  • 1





    Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

    – Rui F Ribeiro
    Jan 4 at 10:10







  • 1





    @Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

    – Stephen Kitt
    Jan 4 at 10:17
















Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

– Stephen Kitt
Jan 4 at 9:40





Did you delete your previous questions on the topic? If so, this might have been answered already, but wouldn’t it be simpler for you to stay on Debian 8, which includes PHP 5.6.39, or even Debian 7 (for which extended support is available), which has PHP 5.4.45? Or are PHP 5.6, 5.4 and 5.3 mutually incompatible?

– Stephen Kitt
Jan 4 at 9:40













@Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

– dubis
Jan 4 at 9:42






@Stephen Kitt. Yes I deleted it because I found this [solution] (unix.stackexchange.com/questions/379215/…) I'm already in DEBIAN I can not downgrade the OS. I already installed PHP 5.6.39 from source.

– dubis
Jan 4 at 9:42














The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

– dubis
Jan 4 at 10:05





The solution above doesn't manage PHP-FPM. The error is arriving during php-fpm compilation step

– dubis
Jan 4 at 10:05




1




1





Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

– Rui F Ribeiro
Jan 4 at 10:10






Mixing libssl versions eg using the wrong version, even if it compiles, it's a recipe for disaster. You would be better off using containers technology or some other isolation technology with the actual Debian binaries of the versions you need.

– Rui F Ribeiro
Jan 4 at 10:10





1




1





@Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

– Stephen Kitt
Jan 4 at 10:17





@Rui it’s doable, as long as you never link two libraries which each need different versions of libssl (with different sonames).

– Stephen Kitt
Jan 4 at 10:17










1 Answer
1






active

oldest

votes


















0














The catalog of Debian snapshots of libpq4 indicates that the last version of PostgreSQL to provide libpq4 was the 8.1 series; you can get the source code for the last release of that (8.1.23) from PostgreSQL.



(You could try using the binary packages from snapshots, but I’m not sure the dependencies would be satisfiable without conflict in Debian 9.)






share|improve this answer






















    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "106"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f492425%2fhow-to-install-libpq-so-4-x-on-debian-9%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    The catalog of Debian snapshots of libpq4 indicates that the last version of PostgreSQL to provide libpq4 was the 8.1 series; you can get the source code for the last release of that (8.1.23) from PostgreSQL.



    (You could try using the binary packages from snapshots, but I’m not sure the dependencies would be satisfiable without conflict in Debian 9.)






    share|improve this answer



























      0














      The catalog of Debian snapshots of libpq4 indicates that the last version of PostgreSQL to provide libpq4 was the 8.1 series; you can get the source code for the last release of that (8.1.23) from PostgreSQL.



      (You could try using the binary packages from snapshots, but I’m not sure the dependencies would be satisfiable without conflict in Debian 9.)






      share|improve this answer

























        0












        0








        0







        The catalog of Debian snapshots of libpq4 indicates that the last version of PostgreSQL to provide libpq4 was the 8.1 series; you can get the source code for the last release of that (8.1.23) from PostgreSQL.



        (You could try using the binary packages from snapshots, but I’m not sure the dependencies would be satisfiable without conflict in Debian 9.)






        share|improve this answer













        The catalog of Debian snapshots of libpq4 indicates that the last version of PostgreSQL to provide libpq4 was the 8.1 series; you can get the source code for the last release of that (8.1.23) from PostgreSQL.



        (You could try using the binary packages from snapshots, but I’m not sure the dependencies would be satisfiable without conflict in Debian 9.)







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 4 at 9:58









        Stephen KittStephen Kitt

        167k24376454




        167k24376454



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Unix & Linux Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f492425%2fhow-to-install-libpq-so-4-x-on-debian-9%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown






            Popular posts from this blog

            How to check contact read email or not when send email to Individual?

            Displaying single band from multi-band raster using QGIS

            How many registers does an x86_64 CPU actually have?