public inbox for [email protected]help / color / mirror / Atom feed
Where does PostgreSQL store extensions on OpenSUSE? 4+ messages / 3 participants [nested] [flat]
* Where does PostgreSQL store extensions on OpenSUSE? @ 2021-06-09 11:07 Simon Connah <[email protected]> 2021-06-09 13:39 ` Re: Where does PostgreSQL store extensions on OpenSUSE? Keith <[email protected]> 2021-06-09 13:41 ` Re: Where does PostgreSQL store extensions on OpenSUSE? Tom Lane <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Simon Connah @ 2021-06-09 11:07 UTC (permalink / raw) To: [email protected] <[email protected]> Hi, My old computer broke and I've completely forgotten where OpenSUSE stores its PostgreSQL extensions. I've been searching with DuckDuckGo but no luck. Is there a quick command to find out where to put them? Thank you. Simon. Attachments: [application/pgp-signature] signature.asc (249B, ../../oNSlA8Dn47Wlze40bY8YxISpzRdgxAEECBRA6Hi-5VfRa5ycc6SHisHfV2RZw4FuTxf2f9NwmWSWxoUuOhQS06Pcyt8kPrS7y2Us9tW6AkM=@protonmail.com/2-signature.asc) download ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where does PostgreSQL store extensions on OpenSUSE? 2021-06-09 11:07 Where does PostgreSQL store extensions on OpenSUSE? Simon Connah <[email protected]> @ 2021-06-09 13:39 ` Keith <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Keith @ 2021-06-09 13:39 UTC (permalink / raw) To: Simon Connah <[email protected]>; +Cc: [email protected] <[email protected]> If you can run the "pg_config" binary, it should be able to show you where SHAREDIR and LIBDIR are. Extension files are kept in $SHAREDIR/extensions and any library files that may be associated with them will be in $LIBDIR. Example for my custom build... $ pg_config BINDIR = /opt/pgsql1302/bin DOCDIR = /opt/pgsql1302/share/doc HTMLDIR = /opt/pgsql1302/share/doc INCLUDEDIR = /opt/pgsql1302/include PKGINCLUDEDIR = /opt/pgsql1302/include INCLUDEDIR-SERVER = /opt/pgsql1302/include/server LIBDIR = /opt/pgsql1302/lib [...] On Wed, Jun 9, 2021 at 7:07 AM Simon Connah <[email protected]> wrote: > Hi, > > My old computer broke and I've completely forgotten where OpenSUSE stores > its PostgreSQL extensions. I've been searching with DuckDuckGo but no luck. > Is there a quick command to find out where to put them? > > Thank you. > > Simon. > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where does PostgreSQL store extensions on OpenSUSE? 2021-06-09 11:07 Where does PostgreSQL store extensions on OpenSUSE? Simon Connah <[email protected]> @ 2021-06-09 13:41 ` Tom Lane <[email protected]> 2021-06-09 15:04 ` Re: Where does PostgreSQL store extensions on OpenSUSE? Simon Connah <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Tom Lane @ 2021-06-09 13:41 UTC (permalink / raw) To: Simon Connah <[email protected]>; +Cc: [email protected] <[email protected]> Simon Connah <[email protected]> writes: > My old computer broke and I've completely forgotten where OpenSUSE stores its PostgreSQL extensions. I've been searching with DuckDuckGo but no luck. Is there a quick command to find out where to put them? If pg_config is installed, see "pg_config --sharedir" --- extension-related text files should be under the extension/ subdirectory of that. Meanwhile, any related .so files should be in "pg_config --libdir" (or maybe it's --pkglibdir? Not sure because they're the same by default) regards, tom lane ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Where does PostgreSQL store extensions on OpenSUSE? 2021-06-09 11:07 Where does PostgreSQL store extensions on OpenSUSE? Simon Connah <[email protected]> 2021-06-09 13:41 ` Re: Where does PostgreSQL store extensions on OpenSUSE? Tom Lane <[email protected]> @ 2021-06-09 15:04 ` Simon Connah <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Simon Connah @ 2021-06-09 15:04 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] <[email protected]> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Wednesday, June 9th, 2021 at 14:41, Tom Lane <[email protected]> wrote: > Simon Connah [email protected] writes: > > > My old computer broke and I've completely forgotten where OpenSUSE stores its PostgreSQL extensions. I've been searching with DuckDuckGo but no luck. Is there a quick command to find out where to put them? > > If pg_config is installed, see "pg_config --sharedir" --- > > extension-related text files should be under the extension/ > > subdirectory of that. Meanwhile, any related .so files should > > be in "pg_config --libdir" (or maybe it's --pkglibdir? Not sure > > because they're the same by default) > > regards, tom lane Awesome. Thank you both. That solved the problem. Simon. Attachments: [application/pgp-signature] signature.asc (249B, ../../hmr_Fz9NyK18gvPqK-BcMUK4bjjD1zkqKXBga9pM_gifSPlic1oRPYY2wNLxaM1BYogUMRTSSerpffwvK9BIVe12VXooIDswCz_cxq47a6g=@protonmail.com/2-signature.asc) download ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-06-09 15:04 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-06-09 11:07 Where does PostgreSQL store extensions on OpenSUSE? Simon Connah <[email protected]> 2021-06-09 13:39 ` Keith <[email protected]> 2021-06-09 13:41 ` Tom Lane <[email protected]> 2021-06-09 15:04 ` Simon Connah <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox