Re: Reconfiguring active PostgreSQL instance

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Tue, 21 Dec 2021 17:08:17 +0200



    On 21/12/21 4:00 μ.μ., Achilleas
      Mantzios wrote:

    
      On 21/12/21 3:42 μ.μ., Reno, Natalie
        wrote:

      
          We provide a PostgreSQL instance that we
            configure ourselves. An application is now needing the
            uuid-ossp extension which requires the –with-uuid=ossp flag
            added to the configuration. When we did the original
            configuration, we did the entire world which means the
            libraries are available. Is there any way to add this to the
            configuration without having to re-run the make and
            installs? Or is there a way around this like copying the
            .sql and .lib files to the appropriate directories? Or can
            the configure statement be run again with just the new flag?
        
      
      My gut is telling me you won't need to recompile. (since you are
      compiling from the source tree, with the source include files),
      but you need to check.

      Why don't you give it a try the easy way first? Do you have a test
      system?

    
    confirmed, with 11.x , ossp-uuid-1.6.2_9 and FreeBSD 11.4

    Side note: you might to play (unset) USE_PGXS 

    
          Here is what we run for each install:
           
               ./configure --prefix=${POSTGRES_DIR}
            --bindir=${POSTGRES_DIR}/bin --sbindir=${POSTGRES_DIR}/sbin
            --libexecdir=${POSTGRES_DIR}/libexec
            --sysconfdir=${POSTGRES_DIR}/etc
            --libdir=${POSTGRES_DIR}/lib
            --includedir=${POSTGRES_DIR}/include
            --datadir=${POSTGRES_DIR}/data --mandir=${POSTGRES_DIR}/man
            --docdir=${POSTGRES_DIR}/doc --htmldir=${POSTGRES_DIR}/doc
            --dvidir=${POSTGRES_DIR}/doc --pdfdir=${POSTGRES_DIR}/doc
            --psdir=${POSTGRES_DIR}/doc --with-perl  --with-systemd
            --with-pam
           
             make world
             make install
             make install-docs
             make install-world
           
          Here is what is in the contrib directory:
          /u01/app/postgres/product/postgresql/contrib/uuid-ossp>ls
          expected/  Makefile  sql/ 
            uuid-ossp--1.0--1.1.sql  uuid-ossp--1.1.sql  uuid-ossp.c 
            uuid-ossp.control  uuid-ossp--unpackaged--1.0.sql
           
          Natalie Reno
                  (she/her/hers)
          Lead Database
              Administrator
          Database Infrastructure
              Team
          Research IT
          Cincinnati Children's
                Hospital
          natalie.reno@xxxxxxxxx
          513.803.5370
           
        
      -- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
    
    
    -- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt