Re: postgres source code installation vs rpm based installation

Hello Mark,

here is the use case in can see to choose Multiple postgres installation on
same server.

>>Re 2: not sure (I use debs not rpms), however typically the install path
>>for binaries is fixed (i.e so you cannot install the same version in
>>multiple places). Also I'm not clear why you would want to do this.

1. Imagine a case where binaries got corrupted. what will happen to the
database cluster?
2. One of the database had problem and need to apply bug fix patch at
binaries. how do we handle this problem?
3. minor release

If we need to host two critical database on one server, I want to keep them
as much Individual as possible(postgres binaries, separate database
cluster, separate file system etc), so that problem to one database cluster
should not cause issue to another database cluster.

On Tue, Jun 4, 2019 at 5:49 PM Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
wrote:

> On 5/06/19 8:00 AM, Pavan Kumar wrote:
> > Hello Experts,
> >
> > I have couple of questions on postgres installation.
> >
> > 1. which way of installation is better ? source code or rpm based ?
> > 2. for instance , If we need to install same version postgres on
> > multiple times on same server. how do we need to handle this with rpm ?
> > 3. If I go with source code installation, in case we need to upgrade
> > OS(6 to 7) , do we need to recompile existing postgres binaries ?
> >
> > kindly share your experience.
> >
> >
>
> Hi,
>
> Some thoughts on these points:
>
> Re 1: Source based is better if you want to customize compile time
> variables (block size etc). However the (substantial) down side of that
> approach is you need to be rebuilding for all the point releases (i.e
> bug and security updates) as they come out- it is easy to forget or not
> bother and end up way behind. This is where the rpm approach shines as
> it does this for you.
>
> Re 2: not sure (I use debs not rpms), however typically the install path
> for binaries is fixed (i.e so you cannot install the same version in
> multiple places). Also I'm not clear why you would want to do this.
>
> Re 3: you might need to recompile in some cases after an upgrade
> (dynamic linking to libraries outside the Postgres src that can get
> their versions changed to the point where Postgres libs won't load
> anymore). However testing should highlight this.
>
> regards
>
> Mark
>
>
>

--

*Regards,#! Pavan Kumar----------------------------------------------*-
*Sr. Database Administrator..!*
*NEXT GENERATION PROFESSIONALS, LLC*
*Cell # 267-799-3182 # pavan.dba27 (Gtalk) *
*India # 9000459083*

*Take Risks; if you win, you will be very happy. If you lose you will be
Wise *