Re: Customize the install directory of the postgres DB

Hi all,

Thanks for the suggestion, i have tried out the option Thomas has mentioned
by unzipping the db, and it works in our scenario. Just a question regarding
the shared library. I have run the following command so that postgres can
locate the shared library

/sbin/ldconfig /home/app/pgsql/lib

Below is the result after i executed it, are the following message expected?
will it cause any issue on the postgres db?

*/sbin/ldconfig: /home/app/pgsql/lib/libpgtypes.so.3 is not a symbolic link
/sbin/ldconfig: /home/app/pgsql/lib/libuuid.so.16 is not a symbolic link
/sbin/ldconfig: /home/app/pgsql/lib/libpq.so.5 is not a symbolic link
/sbin/ldconfig: /home/app/pgsql/lib/libecpg.so.6 is not a symbolic link
/sbin/ldconfig: /home/app/pgsql/lib/libecpg_compat.so.3 is not a symbolic
link
*
Thanks again.
Wei Xiang

On Sat, Nov 14, 2009 at 7:10 AM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:

> Tom Lane wrote:
>
>> The real problem that I think the OP hasn't considered is whether
>> his "bundled" RPM package isn't going to conflict with a preinstalled
>> postgresql RPM. Relocating the RPM, either dynamically as you suggest
>> or by just changing the install paths while building it, isn't a very
>> palatable solution since e.g. you really want libpq.so in /usr/lib,
>> psql in /usr/bin/, etc.
>>
>>
> It sounds like they really do want all of those things to be installed in a
> subdirectory of their app, so I don't see a problem with them being there
> instead of the standard locations. As long as they know how to run psql
> etc., not having them in the global PATH might be a feature rather than a
> problem. The only detail I'm aware of they may not have considered is that
> a subdirectory install has the potential for the binaries to not be able to
> find their associated libraries, so they might either have to add those to
> the system loader configuration or set LD_LIBRARY_PATH before calling
> database binaries. Ideally you'd find them via rpath or something so this
> isn't an issue, but it's easy to miss that the first time you make a change
> like this.
>
>
> --
> Greg Smith 2ndQuadrant Baltimore, MD
> PostgreSQL Training, Services and Support
> greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
>
>