Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYFkc-00084B-1J for pgsql-admin@arkaria.postgresql.org; Tue, 04 Jun 2019 20:09:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hYFka-0002Vb-V0 for pgsql-admin@arkaria.postgresql.org; Tue, 04 Jun 2019 20:09:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYFka-0002VU-K2 for pgsql-admin@lists.postgresql.org; Tue, 04 Jun 2019 20:09:40 +0000 Received: from mail-oi1-x244.google.com ([2607:f8b0:4864:20::244]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYFkY-0002xn-Bl for pgsql-admin@lists.postgresql.org; Tue, 04 Jun 2019 20:09:40 +0000 Received: by mail-oi1-x244.google.com with SMTP id w196so7058167oie.7 for ; Tue, 04 Jun 2019 13:09:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=aGLsBm0ZhnLRuKp7Th3ZySqn+LqAh+pjopqoKx2QUPA=; b=G/JstJjJFD9nqy6u+lUl4aSlgZG0I4/f5aUfaB/B+AzR/UChIZOvl7IsRy8M6nG4mw vhOIEMxOLeMmqEZL1Y3oLATiLJypagyi1TE/GmBsON0uZhQDMCItX0D0d4/UzKKZVPKZ 2MFu/0CPyVRsSwOJlGjrdTOVaA0m16WSHPUY4H+Ghvi63BMJFaRfpPSxb0BnGm4F711B rSncsTe7m09irxIeejRqxXVYANB0gtwWIVbooOsFami09+1fBVRMfvhzNsg5aCpmmTvP WSPkIMB1nUmJwj7CKtrO1oPqpSqgDkuWn0e5IiRjQIKZlkoYTC7inp97FuQdTh4zP0KU AAkQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=aGLsBm0ZhnLRuKp7Th3ZySqn+LqAh+pjopqoKx2QUPA=; b=bzrF3u0Faq7cv6ciIrBp0Xct3H2eHD7vdv+K1Cw5s8zSbEGXeCMv6NJSWQ+9k4rsKP hzJyXzdE31z3VhIskXrUPufwL0GVMgHmrensAZk319ZB4e3r7M6Oy1BlsCQelvYZd6X7 gYgSuxXXHZCcxlNhu2v7dnx7M8RY6k4kdMTRb82iX3oKMUJsoJbhpnYu/yDeJhUxJH6z AM2UXsHCVUt566sANJq+9tKHGYrX7Cx/Gr3kbpdPjufcP50iCOSYIbmq6B6KkSmRAT7d WTn9yLb1LPG551boA2D/DYSk4ksgS/mONYBfbvVouS5OBVF6cjYVXy+6ITt6KONmVIdg 12Zg== X-Gm-Message-State: APjAAAWWqELBqqo/TviMn55CAfl3Wm64hxaEXfyoWtZ7qRq7D3Cj+0QV 1Q5K2yxoPH9p++p1WP25wiXm8NkR2QY= X-Google-Smtp-Source: APXvYqzAnqUDcYClAlIVRFPNHevEwDUo3uK6EVk2n/Xu4f3lyju/Aevwemf4UGhjBzyVZjRCDpwnSA== X-Received: by 2002:aca:aad3:: with SMTP id t202mr2062833oie.158.1559678976054; Tue, 04 Jun 2019 13:09:36 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id n7sm6982471oih.18.2019.06.04.13.09.35 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 04 Jun 2019 13:09:35 -0700 (PDT) Subject: Re: postgres source code installation vs rpm based installation To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <877bcb21-d071-9c78-9ce7-c1446c4aca39@gmail.com> Date: Tue, 4 Jun 2019 15:09:34 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.