pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres source code installation vs rpm based installation
9+ messages / 6 participants
[nested] [flat]
* postgres source code installation vs rpm based installation
@ 2019-06-04 20:00 Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Re: postgres source code installation vs rpm based installation Ron <ronljohnsonjr@gmail.com>
2019-06-04 22:50 ` Re: postgres source code installation vs rpm based installation Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 2 replies; 9+ messages in thread
From: Pavan Kumar @ 2019-06-04 20:00 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
--
*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 *
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-06-04 20:09 ` Ron <ronljohnsonjr@gmail.com>
2019-06-04 20:49 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Ron @ 2019-06-04 20:09 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 6/4/19 3:00 PM, 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 ?
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.)
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Re: postgres source code installation vs rpm based installation Ron <ronljohnsonjr@gmail.com>
@ 2019-06-04 20:49 ` Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:58 ` Re: postgres source code installation vs rpm based installation David G. Johnston <david.g.johnston@gmail.com>
2019-06-04 21:26 ` Re: postgres source code installation vs rpm based installation Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 9+ messages in thread
From: Pavan Kumar @ 2019-06-04 20:49 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.
I want to hear experts thoughts on this .
kindly advise
On Tue, Jun 4, 2019 at 3:09 PM Ron <ronljohnsonjr@gmail.com> wrote:
> On 6/4/19 3:00 PM, 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 ?
>
> 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.)
>
> --
> Angular momentum makes the world go 'round.
>
>
>
--
*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 *
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Re: postgres source code installation vs rpm based installation Ron <ronljohnsonjr@gmail.com>
2019-06-04 20:49 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-06-04 20:58 ` David G. Johnston <david.g.johnston@gmail.com>
2019-06-05 14:14 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: David G. Johnston @ 2019-06-04 20:58 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Tue, Jun 4, 2019 at 1:50 PM Pavan Kumar <pavan.dba27@gmail.com> 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.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Re: postgres source code installation vs rpm based installation Ron <ronljohnsonjr@gmail.com>
2019-06-04 20:49 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:58 ` Re: postgres source code installation vs rpm based installation David G. Johnston <david.g.johnston@gmail.com>
@ 2019-06-05 14:14 ` Pavan Kumar <pavan.dba27@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Pavan Kumar @ 2019-06-05 14:14 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
>>Installing the same binaries multiple times to different locations on the
same machine goes against the design of PostgreSQL.
Having multiple installation of same postgres version is not supported by
postgres ?
Is it correct statement ?
Thank you..
On Tue, Jun 4, 2019 at 3:59 PM David G. Johnston <david.g.johnston@gmail.com>
wrote:
> On Tue, Jun 4, 2019 at 1:50 PM Pavan Kumar <pavan.dba27@gmail.com> 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.
>
>
--
*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 *
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Re: postgres source code installation vs rpm based installation Ron <ronljohnsonjr@gmail.com>
2019-06-04 20:49 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-06-04 21:26 ` Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 9+ messages in thread
From: Scott Ribe @ 2019-06-04 21:26 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
> On Jun 4, 2019, at 2:49 PM, Pavan Kumar <pavan.dba27@gmail.com> wrote:
>
> 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.
You are thinking clearly ;-)
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-06-04 22:50 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2019-06-05 14:23 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Mark Kirkwood @ 2019-06-04 22:50 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 22:50 ` Re: postgres source code installation vs rpm based installation Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
@ 2019-06-05 14:23 ` Pavan Kumar <pavan.dba27@gmail.com>
2019-06-05 14:47 ` Re: postgres source code installation vs rpm based installation Rui DeSousa <rui@crazybean.net>
0 siblings, 1 reply; 9+ messages in thread
From: Pavan Kumar @ 2019-06-05 14:23 UTC (permalink / raw)
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.kirkwood@catalyst.net.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 *
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: postgres source code installation vs rpm based installation
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 22:50 ` Re: postgres source code installation vs rpm based installation Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2019-06-05 14:23 ` Re: postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-06-05 14:47 ` Rui DeSousa <rui@crazybean.net>
0 siblings, 0 replies; 9+ messages in thread
From: Rui DeSousa @ 2019-06-05 14:47 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; +Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Jun 5, 2019, at 10:23 AM, Pavan Kumar <pavan.dba27@gmail.com> wrote:
>
> 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
Custom builds sounds like the solution you need. I wouldn’t install the same version multiple times; however, having two different patch releases makes sense. For example, install one version of 10.1 and use it for multiple database clusters. Install version 10.2 in a different directory and update a given database cluster environment to use 10.2 binaries thus allowing for both 10.1 and 10.2 to be running on the same server.
I don’t think RPMs will allow you to run different patch releases.
P.s.
I have both 10.7 and 11.3 running on the same system without issue. Normally run one database cluster on the system; however, currently migrating between major versions and using the system for testing and migration efforts.
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2019-06-05 14:47 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-04 20:00 postgres source code installation vs rpm based installation Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:09 ` Ron <ronljohnsonjr@gmail.com>
2019-06-04 20:49 ` Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 20:58 ` David G. Johnston <david.g.johnston@gmail.com>
2019-06-05 14:14 ` Pavan Kumar <pavan.dba27@gmail.com>
2019-06-04 21:26 ` Scott Ribe <scott_ribe@elevated-dev.com>
2019-06-04 22:50 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2019-06-05 14:23 ` Pavan Kumar <pavan.dba27@gmail.com>
2019-06-05 14:47 ` Rui DeSousa <rui@crazybean.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox