Re: Reconfiguring active PostgreSQL instance

Holger Jakobs <holger@xxxxxxxxxx> · Tue, 21 Dec 2021 16:33:27 +0100

  The path looks like it's a very unconventional installation. Usually, it should be something like /usr/local/... if it's on a unixoide system.

Maybe it's a Mac. This should be mentioned in the question.

Am 21. Dezember 2021 16:27:17 MEZ schrieb "Gogala, Mladen" <gogala.mladen@xxxxxxxxx>:

    Hi Natalie,
    It looks like the extension is not properly installed.
    Regards

    On 12/21/2021 10:15 AM, Reno, Natalie
      wrote:

        glimps_db_t=> create extension
          "uuid-ossp" ;
        ERROR:  could not open extension control
          file
"/u01/app/postgres/product/postgresql-12.8/data/extension/uuid-ossp.control":
          No such file or directory

        Should I copy the control file over from
          the contrib directory?

          Natalie Reno
                  (she/her/hers)
          Lead Database
              Administrator
          Database Infrastructure
              Team
          Research IT
          Cincinnati Children's
                Hospital
          natalie.reno@xxxxxxxxx
          513.803.5370

            From: David G. Johnston
              <david.g.johnston@xxxxxxxxx> 

              Sent: Tuesday, December 21, 2021 10:11 AM

              To: Reno, Natalie <Natalie.Reno@xxxxxxxxx>

              Cc: Pgsql-admin
              <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>

              Subject: Re: Reconfiguring active PostgreSQL
              instance

                This
                      email originated from an EXTERNAL sender to CCHMC.
                      Proceed with caution when replying, opening
                      attachments, or clicking links in this message.

                  On Tue, Dec 21, 2021, 06:42 Reno,
                    Natalie <Natalie.Reno@xxxxxxxxx>
                    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. 

              So what happens when you execute
                create extension?

              David J.-- 

    This email has originated from an
            extremely suspect and sometimes very grumpy sender. Proceed
            with extreme caution and use the Force, if possible.

    Hi Natalie,
    It looks like the extension is not properly installed.
    Regards

    Mladen Gogala

      Oracle DBA

      Tel: (347) 321-1217

      Blog: https://dbwhisperer.wordpress.com

-- 
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -