pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReconfiguring active PostgreSQL instance
16+ messages / 10 participants
[nested] [flat]
* Reconfiguring active PostgreSQL instance
@ 2021-12-21 13:42 Reno, Natalie <Natalie.Reno@cchmc.org>
0 siblings, 4 replies; 16+ messages in thread
From: Reno, Natalie @ 2021-12-21 13:42 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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?
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@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 14:00 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
3 siblings, 1 reply; 16+ messages in thread
From: Achilleas Mantzios @ 2021-12-21 14:00 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?
>
> 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@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:08 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 16+ messages in thread
From: Achilleas Mantzios @ 2021-12-21 15:08 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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@cchmc.org <mailto:natalie.reno@cchmc.org>
>>
>> 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
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:10 David G. Johnston <david.g.johnston@gmail.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
3 siblings, 1 reply; 16+ messages in thread
From: David G. Johnston @ 2021-12-21 15:10 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Tue, Dec 21, 2021, 06:42 Reno, Natalie <Natalie.Reno@cchmc.org> 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.
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* RE: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:15 Reno, Natalie <Natalie.Reno@cchmc.org>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 16+ messages in thread
From: Reno, Natalie @ 2021-12-21 15:15 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Tuesday, December 21, 2021 10:11 AM
To: Reno, Natalie <Natalie.Reno@cchmc.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@cchmc.org<mailto:Natalie.Reno@cchmc.org>> 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.
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:27 Gogala, Mladen <gogala.mladen@gmail.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
1 sibling, 1 reply; 16+ messages in thread
From: Gogala, Mladen @ 2021-12-21 15:27 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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@cchmc.org
>
> 513.803.5370
>
> *From:* David G. Johnston <david.g.johnston@gmail.com>
> *Sent:* Tuesday, December 21, 2021 10:11 AM
> *To:* Reno, Natalie <Natalie.Reno@cchmc.org>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> *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@cchmc.org> 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
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:33 Holger Jakobs <holger@jakobs.com>
parent: Gogala, Mladen <gogala.mladen@gmail.com>
0 siblings, 2 replies; 16+ messages in thread
From: Holger Jakobs @ 2021-12-21 15:33 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org, "Gogala, Mladen" <gogala.mladen@gmail.com>
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@gmail.com>:
>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@cchmc.org
>>
>> 513.803.5370
>>
>> *From:* David G. Johnston <david.g.johnston@gmail.com>
>> *Sent:* Tuesday, December 21, 2021 10:11 AM
>> *To:* Reno, Natalie <Natalie.Reno@cchmc.org>
>> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
>> *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@cchmc.org> 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 -
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 15:37 Dai, Tino <tdai@loc.gov>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 1 reply; 16+ messages in thread
From: Dai, Tino @ 2021-12-21 15:37 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Gogala, Mladen <gogala.mladen@gmail.com>
Is it AIX? The /u01 feels like AIX. -T
________________________________
From: Holger Jakobs <holger@jakobs.com>
Sent: Tuesday, December 21, 2021 10:33 AM
To: pgsql-admin@lists.postgresql.org; Gogala, Mladen
Subject: Re: Reconfiguring active PostgreSQL instance
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@gmail.com>:
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@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
From: David G. Johnston <david.g.johnston@gmail.com><mailto:david.g.johnston@gmail.com>
Sent: Tuesday, December 21, 2021 10:11 AM
To: Reno, Natalie <Natalie.Reno@cchmc.org><mailto:Natalie.Reno@cchmc.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org><mailto:pgsql-admin@lists.postgresql.org>
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@cchmc.org<mailto:Natalie.Reno@cchmc.org>> 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 -
^ permalink raw reply [nested|flat] 16+ messages in thread
* RE: Reconfiguring active PostgreSQL instance
@ 2021-12-21 16:00 Reno, Natalie <Natalie.Reno@cchmc.org>
parent: Dai, Tino <tdai@loc.gov>
0 siblings, 2 replies; 16+ messages in thread
From: Reno, Natalie @ 2021-12-21 16:00 UTC (permalink / raw)
To: Dai, Tino <tdai@loc.gov>; Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Gogala, Mladen <gogala.mladen@gmail.com>
This is on Linux. It is a custom install. We don't use RPMs but the tar ball of the binaries. This is why we have the config file when we create the software.
Natalie Reno (she/her/hers)
Lead Database Administrator
Database Infrastructure Team
Research IT
Cincinnati Children's Hospital
natalie.reno@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
From: Dai, Tino <tdai@loc.gov>
Sent: Tuesday, December 21, 2021 10:38 AM
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org; Gogala, Mladen <gogala.mladen@gmail.com>
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.
Is it AIX? The /u01 feels like AIX. -T
________________________________
From: Holger Jakobs <holger@jakobs.com<mailto:holger@jakobs.com>>
Sent: Tuesday, December 21, 2021 10:33 AM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>; Gogala, Mladen
Subject: Re: Reconfiguring active PostgreSQL instance
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@gmail.com<mailto:gogala.mladen@gmail.com>>:
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@cchmc.org<mailto:natalie.reno@cchmc.org>
513.803.5370
From: David G. Johnston <david.g.johnston@gmail.com><mailto:david.g.johnston@gmail.com>
Sent: Tuesday, December 21, 2021 10:11 AM
To: Reno, Natalie <Natalie.Reno@cchmc.org><mailto:Natalie.Reno@cchmc.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org><mailto:pgsql-admin@lists.postgresql.org>
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@cchmc.org<mailto:Natalie.Reno@cchmc.org>> 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 -
^ permalink raw reply [nested|flat] 16+ messages in thread
* RE: Reconfiguring active PostgreSQL instance
@ 2021-12-21 18:48 Michel SALAIS <msalais@msym.fr>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
3 siblings, 0 replies; 16+ messages in thread
From: Michel SALAIS @ 2021-12-21 18:48 UTC (permalink / raw)
To: 'Reno, Natalie' <Natalie.Reno@cchmc.org>; pgsql-admin@lists.postgresql.org
Hi,
Have you done “at least” the following
cd /u01/app/postgres/product/postgresql/contrib/uuid-ossp
make
make install
Michel SALAIS
De : Reno, Natalie <Natalie.Reno@cchmc.org>
Envoyé : mardi 21 décembre 2021 14:43
À : pgsql-admin@lists.postgresql.org
Objet : Reconfiguring active PostgreSQL instance
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?
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
<mailto:natalie.reno@cchmc.org> natalie.reno@cchmc.org
513.803.5370
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 19:51 Gavan Schneider <list.pg.gavan@pendari.org>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 16+ messages in thread
From: Gavan Schneider @ 2021-12-21 19:51 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org, "Gogala, Mladen" <gogala.mladen@gmail.com>
On 22 Dec 2021, at 2:33, Holger Jakobs wrote:
> 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.
>
FWIW Mac is BSD Unix making /usr/local/… the place to put postgres etc.
As mentioned by OP the installation is custom so they may not have followed this convention on their *nix system, and, taking macOS as an example, installations into non standard directories can come against security features.
Regards
Gavan Schneider
——
Gavan Schneider, Sodwalls, NSW, Australia
Explanations exist; they have existed for all time; there is always a well-known solution to every human problem — neat, plausible, and wrong.
— H. L. Mencken, 1920
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 20:28 David G. Johnston <david.g.johnston@gmail.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
1 sibling, 0 replies; 16+ messages in thread
From: David G. Johnston @ 2021-12-21 20:28 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: Dai, Tino <tdai@loc.gov>; Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Gogala, Mladen <gogala.mladen@gmail.com>
On Tuesday, December 21, 2021, Reno, Natalie <Natalie.Reno@cchmc.org> wrote:
> This is on Linux. It is a custom install. We don’t use RPMs but the tar
> ball of the binaries. This is why we have the config file when we create
> the software.
>
Please don’t top-post. Inline or bottom posting with trimming is customary
here.
I’m not a source installer (or tar ball binary) expert but you seem
confused by what ./configure ‘s role is in all of this. You claim to have
installed world yet the error message you are seeing clearly indicates the
server in question doesn’t see the compiled extension. And its concept of
where to look for it is vastly different than your own. At this point you
might as well just try copying files around and hoping that it works. But
personally I’d suggest just strictly building from source with your desired
customizations in a controlled (scripted) manner.
David J.
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 20:44 Michael Banck <michael.banck@credativ.de>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
3 siblings, 0 replies; 16+ messages in thread
From: Michael Banck @ 2021-12-21 20:44 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
On Tue, Dec 21, 2021 at 01:42:41PM +0000, Reno, Natalie wrote:
> We provide a PostgreSQL instance that we configure ourselves.
Just saying, but this would not have been a problem if you had used the
RPM packages.
> 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.
I guess you mean you ran "make world"?
> 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?
> 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
It /should/ work if you add --with-uuid=something to the above line,
rerun it and then change intro the contrib/uuid-ossp/ directory and run
"make" followed by "make install" from there. Then, "CREATE EXTENSION"
should work.
However, to be sure, I advise to make a backup of the full (built)
source tree beforehand and to try it on a test/development instance
first.
Which uuid library you prefer (and replace for "something" above) should
be something you can figure out yourself.
Michael
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 21:05 Edward J. Sabol <edwardjsabol@gmail.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
1 sibling, 1 reply; 16+ messages in thread
From: Edward J. Sabol @ 2021-12-21 21:05 UTC (permalink / raw)
To: Reno, Natalie <Natalie.Reno@cchmc.org>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Dec 21, 2021, at 10:15 AM, Reno, Natalie <Natalie.Reno@cchmc.org> wrote:
> Should I copy the control file over from the contrib directory?
I install from source, too. For the extensions that I install, I go into the extensions directory and type "make", followed by "make test", followed by "make install". "make install" will install the extension where it needs to go, assuming your environment is configured properly (check the output of "pg_config" first). After you've successfully "make install", "create extension" in psql should work.
Hope this helps,
Ed
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: Reconfiguring active PostgreSQL instance
@ 2021-12-21 21:28 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Reno, Natalie <Natalie.Reno@cchmc.org>
1 sibling, 0 replies; 16+ messages in thread
From: Achilleas Mantzios @ 2021-12-21 21:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Στις 21/12/21 6:00 μ.μ., ο/η Reno, Natalie έγραψε:
>
> This is on Linux. It is a custom install. We don’t use RPMs but the
> tar ball of the binaries. This is why we have the config file when we
> create the software.
>
I gave you the solution in a previous mail. You dont need to reinstall
postgresql. You just ./configure --what-ever and then go straight to
compile and install (make install) the contrib module the usual way, (as
root) after you disable USE_PGXS.
Did you try that?
> */Natalie Reno (she/her/hers)/*
>
> Lead Database Administrator
>
> Database Infrastructure Team
>
> /Research IT/
>
> /Cincinnati Children's Hospital/
>
> natalie.reno@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
> *From:* Dai, Tino <tdai@loc.gov>
> *Sent:* Tuesday, December 21, 2021 10:38 AM
> *To:* Holger Jakobs <holger@jakobs.com>;
> pgsql-admin@lists.postgresql.org; Gogala, Mladen <gogala.mladen@gmail.com>
> *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.*
>
> Is it AIX? The /u01 feels like AIX. -T
>
> ------------------------------------------------------------------------
>
> *From:*Holger Jakobs <holger@jakobs.com <mailto:holger@jakobs.com>>
> *Sent:* Tuesday, December 21, 2021 10:33 AM
> *To:* pgsql-admin@lists.postgresql.org
> <mailto:pgsql-admin@lists.postgresql.org>; Gogala, Mladen
> *Subject:* Re: Reconfiguring active PostgreSQL instance
>
> 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@gmail.com <mailto:gogala.mladen@gmail.com>>:
>
> 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@cchmc.org <mailto:natalie.reno@cchmc.org>
>
> 513.803.5370
>
> *From:*David G. Johnston <david.g.johnston@gmail.com>
> <mailto:david.g.johnston@gmail.com>
> *Sent:* Tuesday, December 21, 2021 10:11 AM
> *To:* Reno, Natalie <Natalie.Reno@cchmc.org>
> <mailto:Natalie.Reno@cchmc.org>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.org>
> <mailto:pgsql-admin@lists.postgresql.org>
> *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@cchmc.org <mailto:Natalie.Reno@cchmc.org>> 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
> <https://dbwhisperer.wordpress.com;
>
> --
> Holger Jakobs, Bergisch Gladbach
> +49 178 9759012
> - sent from mobile, therefore short -
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* RE: Reconfiguring active PostgreSQL instance
@ 2021-12-23 18:07 Reno, Natalie <Natalie.Reno@cchmc.org>
parent: Edward J. Sabol <edwardjsabol@gmail.com>
0 siblings, 0 replies; 16+ messages in thread
From: Reno, Natalie @ 2021-12-23 18:07 UTC (permalink / raw)
To: Edward J. Sabol <edwardjsabol@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Thanks for the help. I finally found this in the actual PostgreSQL documentation. Unfortunately, it was erroring out when I tried make install within the uuid-ossp directory. I looked into it for a bit, but I had already done a workaround which was a temporary install of the same software with the uuid-sso configure flags and then copy the library file that was missing from this temporary install to the working one. After that, creating the extension was successful. On our next patch cycle, these will automatically be included. Thanks to everyone for responding.
Natalie Reno (she/her/hers)
Lead Database Administrator
Database Infrastructure Team
Research IT
Cincinnati Children's Hospital
natalie.reno@cchmc.org
513.803.5370
-----Original Message-----
From: Edward J. Sabol <edwardjsabol@gmail.com>
Sent: Tuesday, December 21, 2021 4:06 PM
To: Reno, Natalie <Natalie.Reno@cchmc.org>
Cc: pgsql-admin@lists.postgresql.org
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 Dec 21, 2021, at 10:15 AM, Reno, Natalie <Natalie.Reno@cchmc.org> wrote:
> Should I copy the control file over from the contrib directory?
I install from source, too. For the extensions that I install, I go into the extensions directory and type "make", followed by "make test", followed by "make install". "make install" will install the extension where it needs to go, assuming your environment is configured properly (check the output of "pg_config" first). After you've successfully "make install", "create extension" in psql should work.
Hope this helps,
Ed
^ permalink raw reply [nested|flat] 16+ messages in thread
end of thread, other threads:[~2021-12-23 18:07 UTC | newest]
Thread overview: 16+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-21 13:42 Reconfiguring active PostgreSQL instance Reno, Natalie <Natalie.Reno@cchmc.org>
2021-12-21 14:00 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2021-12-21 15:08 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2021-12-21 15:10 ` David G. Johnston <david.g.johnston@gmail.com>
2021-12-21 15:15 ` Reno, Natalie <Natalie.Reno@cchmc.org>
2021-12-21 15:27 ` Gogala, Mladen <gogala.mladen@gmail.com>
2021-12-21 15:33 ` Holger Jakobs <holger@jakobs.com>
2021-12-21 15:37 ` Dai, Tino <tdai@loc.gov>
2021-12-21 16:00 ` Reno, Natalie <Natalie.Reno@cchmc.org>
2021-12-21 20:28 ` David G. Johnston <david.g.johnston@gmail.com>
2021-12-21 21:28 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2021-12-21 19:51 ` Gavan Schneider <list.pg.gavan@pendari.org>
2021-12-21 21:05 ` Edward J. Sabol <edwardjsabol@gmail.com>
2021-12-23 18:07 ` Reno, Natalie <Natalie.Reno@cchmc.org>
2021-12-21 18:48 ` Michel SALAIS <msalais@msym.fr>
2021-12-21 20:44 ` Michael Banck <michael.banck@credativ.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox