Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fT54x-0005Hj-T2 for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jun 2018 12:40:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fT54w-0001SE-8Z for pgadmin-hackers@arkaria.postgresql.org; Wed, 13 Jun 2018 12:40:46 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fT54w-0001Rc-3d for pgadmin-hackers@lists.postgresql.org; Wed, 13 Jun 2018 12:40:46 +0000 Received: from mail-wm0-x22e.google.com ([2a00:1450:400c:c09::22e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fT54m-0005ud-SH for pgadmin-hackers@postgresql.org; Wed, 13 Jun 2018 12:40:44 +0000 Received: by mail-wm0-x22e.google.com with SMTP id r15-v6so4478913wmc.1 for ; Wed, 13 Jun 2018 05:40:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=w5ajKssuR2fO/+mBPaDp6+YHLTxB04w3Z3tI8fOAIgs=; b=deHFKudx9QItsxLOymUgBu6pG8XycdH9jdx1qeqA7EEjlE5p2PcSjwyIEd7ZzVjdTg KSBHkWNCyTFK13afToWZ/An1QW0wtvxfR6VEfhAp9fu8ptvDerCiYaW51Yr7Tk6w1TGS iYvKzMYhEgRwhBkeFt23OjQaYV+8diy7J+C1QeHR/zIrUZpm/1RBf9JE1rtcdFCsENPk liUp4xUWyT1Tnvze9h73cvz7aHsFiKIY7l98lz9OyDZpeT04TZ4hClhT0aUOiHX+xUkc 69sdtmlu1pcy8YxEDyaVgOSHKgps3l3GruWzN2ncoSOYtxkFs9g/MEM6z6y5MExjVzd9 zodA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=w5ajKssuR2fO/+mBPaDp6+YHLTxB04w3Z3tI8fOAIgs=; b=ltW5y2o5F8ib5UFO0/N9OFlbYx+GjXP84W+1ow8mPzT5yiVxIIaUBDEq0BH/WbdE6A 5k9WIePb9NTMfvn2i/8Jdx9oNr5nlKfCgnDEO0vFgum5TMamKNdyZe2h+vMmZdsWp3mQ bHdc1IlzzIDxTr8v+A1P6EsgR23EkKspqNwPa1AOo7PcWFO21S01L3kKWnk5bDS7l85O eSl1ITRR/WWhv3uaMu15/2gKIX7jd2H7v+FKMaKH1CdJgBygDA9qGQnoGGm/lln8IKG0 EcHxPS1aEJ/FlVvT0lEWBkqdUcN9EeEorDsMUgaLhATgmDSbvu3dy3DBS4APy32ZUOSa AKtw== X-Gm-Message-State: APt69E13oxl2Rj/WNimT7yiawLjDPCPWuOX0l7rULyQlxhI1c/GnJ7sa UKMIFgNFtZ/+ONUNWaG8rXHn5IJW1ea4dcsW3irCiQ== X-Google-Smtp-Source: ADUXVKLjtUkppkSJIvWJZxHz9Tj3NaWoA4rH6vHuPxLK60lkE58I1h0YLd60TdYDRqytkqiRze6ds3auowKYxk0ZdR0= X-Received: by 2002:a1c:443:: with SMTP id 64-v6mr3658793wme.140.1528893635291; Wed, 13 Jun 2018 05:40:35 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a1c:2907:0:0:0:0:0 with HTTP; Wed, 13 Jun 2018 05:40:34 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Wed, 13 Jun 2018 13:40:34 +0100 Message-ID: Subject: Re: [PGAGENT] Upgrade pgAgent from unpackaged version To: Ashesh Vashi Cc: Rushabh Lathia , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000080070056e854a5a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000080070056e854a5a Content-Type: text/plain; charset="UTF-8" Thanks, applied. On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi wrote: > Hi Dave, > > As per my conversation with Rushabh, we need to rename the > pgagent--unpackaged--3.4.sql to pgagent--unpackaged--4.0.sql as it the > current version has changed. We also need to update the schema version > function for the unpackaged extension. > > Please find the attached patch for the same. > > -- > > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL Company > > > > *http://www.linkedin.com/in/asheshvashi* > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --000000000000080070056e854a5a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, applied.

On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Hi Dave,

As per my co= nversation with Rushabh, we need to rename the pgagent--unpackaged--3.4.sql= to pgagent--unpackaged--4.0.sql as it the current version has changed. We = also need to update the schema version function for the unpackaged extensio= n.

Please find the attached patch for the same.

--

Th= anks & Regards,

Ashesh Vashi
Enterpri= seDB INDIA: Enterprise PostgreSQL Company

<= br>

<= a href=3D"http://www.linkedin.com/in/asheshvashi" target=3D"_blank">http= ://www.linkedin.com/in/asheshvashi




--
Dave Page
Blog: = http://pgsnake.bl= ogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com<= br>The Enterprise PostgreSQL Company
--000000000000080070056e854a5a--