Re: postgres source code installation vs rpm based installation

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jun 4, 2019 at 1:50 PM Pavan Kumar <pavan.dba27@xxxxxxxxx> wrote:

Hello Ron,

>>>>>>>Are you a Windows DBA with no Linux or Postgres experience?  (I ask that so
>>>>>>>that we know "where you are" in regards to installing software on Linux.)

I am  not Windows DBA.   I have very good experience on Linux and working on postgres.

I installed postgres in both way's rpm based and source code installation.  

I prefer source code for below reason

       I will have control on postgres software location

       few parameter I can modify with source code installation (like wal-segsize). 

       I can install same version  postgres on multiple times as per our need.

Installing the same binaries multiple times to different locations on the same machine goes against the design of PostgreSQL.

If you need to change things that can only be changed at compile time then your decision has been made.

Otherwise I'd stick with packages as the most well understood installation and upgrade mechanism for your platform.

David J.