RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

From: Kevin Brannen <KBrannen(at)efji(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL
Date: 2019-01-04 15:08:14
Message-ID: MN2PR19MB2575CA31DE92237BBD72459EA48E0@MN2PR19MB2575.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-pkg-yum

From: chiru r <chirupg(at)gmail(dot)com>

> I have tried to intall the RPMs with -relocate option,however it is not working as expected and throwing below error.
>
> [root(at)Server1dev:/root/PG11]#
> #-> rpm -ivh --relocate /usr/pgsql-11/=/u01/postgres/pg11_relocate/ postgresql11-server-11.1-1PGDG.rhel7.x86_64.rpm
> warning: postgresql11-server-11.1-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
> Preparing... ################################# [100%]
> path /usr/pgsql-11 in package postgresql11-server-11.1-1PGDG.rhel7.x86_64 is not relocatable
> [root(at)server1dev:/root/PG11]#

Then you'll probably have to get the source from the Pg download area and compile it yourself and use "--prefix=/u01/postgres/pg11_relocate/" as an arg to the "configure" command. It's not hard, the process is well documented. We do this and 1 reason is to have it install into /opt, although we also compile it ourselves so we know what's going into the install.

It's either that or let it install where it wants to and then put a symlink in the place you want it, as someone else suggested.

HTH,
Kevin
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erika Knihti-Van Driessche 2019-01-04 15:30:21 Re: Multiple postgresql clusters with same version and separate binaries
Previous Message Ron 2019-01-04 15:03:12 Re: Multiple postgresql clusters with same version and separate binaries

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Justin Pryzby 2019-01-07 21:54:10 Re: [PostgreSQL YUM Repository - Bug #3710] (Resolved) RHEL7 postgresql11 postgis2.5 fails with /usr/pgsql-11/lib/postgis-2.5.so: undefined symbol: geod_polygon_init
Previous Message chiru r 2019-01-03 17:23:56 Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL