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 1fTNbH-0005KM-0W for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jun 2018 08:27:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTNbF-0008OG-Gw for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jun 2018 08:27:21 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTNbF-0008O6-8I for pgadmin-hackers@lists.postgresql.org; Thu, 14 Jun 2018 08:27:21 +0000 Received: from mail-wr0-x22d.google.com ([2a00:1450:400c:c0c::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTNbC-0002c2-1S for pgadmin-hackers@postgresql.org; Thu, 14 Jun 2018 08:27:20 +0000 Received: by mail-wr0-x22d.google.com with SMTP id d8-v6so5427332wro.4 for ; Thu, 14 Jun 2018 01:27:17 -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=7xSv4wPzQ0BWH5YdIB97JcbX23s/CibUPsWIMXK8uOs=; b=xpXGWpq8M3nfnybRQwgZ3A+tHbGcaguGuSgQwJpkGO7t9drrLduCX5/M18Ll5UM/cz hpDZmxxzAiUvk/9P70sm9QwmugJ3cackn70DRvyNCCBUD3DIol/lgL0E5yU6blTzjGMg dKc6cZih16awSMAz/XNHWixFRMoFLboIn2zvibv7fOwfSfH/HRU16vj2ExyfnAZ8BjXP BAfe/3jFBvXFD/7Au6iNc2D2OTwstoOFSwUTpSQyYY4LLAp6QRGRCJ3L7bIHWqxpG0/M Y62HJ4PhMlZdqZcYo1/7xqBSXLegleNcCRIK/PzNQwGGpVFPIX88FrkNEv0C1YHdshgl Cwfg== 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=7xSv4wPzQ0BWH5YdIB97JcbX23s/CibUPsWIMXK8uOs=; b=D/8Aa0kMug/ICJIYJF6t10szcUYDw+gbqQPfoAYHb+5cIKxcJzJLishO1Totkxs/57 cHiX0fa1HRXeMYd+LSd6p88uNGowwF8LczOc6R6v58NLyDRtqzfJNSQ96ilJNkeFiB5X 58OJz67cRDCsr/EqGPK/OLsVPxOMppQnJqUE6tM3hvuGv1dat862ej3klSi2u9NwDDih mG0QXWTdop7QfXjxLzHxERW2zgCwiM9smcoTpfELkrBgu4Isx/G0d07lSjz8ECmNd5Pt d3JrUVR5nJU6k/Bqx/7hcXjdtb7bm0OlJNnTHpQSUTLDyJyHRgwIwwyRFHxGCuGJub50 OF0w== X-Gm-Message-State: APt69E1eEjdC7h8lr8m9+2tpjesqPjUKcb7Lv8y5UYGQjopEpAvPMuRF Ezc97bDBcCEq44oFxQwN3ghXFEoZGUugWZPfzVUYCA== X-Google-Smtp-Source: ADUXVKJR3iIeHSDpOMr+aiLtHr+wKgasMIuEaIe47a1QGAxSj61w1yNjg6KI67DfuyexrFI58kPewM5isow0TuWW58w= X-Received: by 2002:adf:8211:: with SMTP id 17-v6mr1273326wrb.144.1528964836359; Thu, 14 Jun 2018 01:27:16 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a1c:2907:0:0:0:0:0 with HTTP; Thu, 14 Jun 2018 01:27:15 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Thu, 14 Jun 2018 09:27:15 +0100 Message-ID: Subject: Re: [PGAGENT] Upgrade pgAgent from unpackaged version To: Rushabh Lathia Cc: Ashesh Vashi , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000f2135e056e95dd6b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000f2135e056e95dd6b Content-Type: text/plain; charset="UTF-8" Thanks Rushabh - patch applied! On Thu, Jun 14, 2018 at 5:49 AM, Rushabh Lathia < rushabh.lathia@enterprisedb.com> wrote: > Thanks Ashesh and Dave. > > I verified the changes and it looks good to me. I found that newly > added unpackaged file still have old file header comment. Which > require change with new file name. > > PFA patch to fix the same. > > Thanks, > > > On Wed, Jun 13, 2018 at 6:10 PM, Dave Page wrote: > >> Thanks, applied. >> >> On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi < >> ashesh.vashi@enterprisedb.com> 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 >> > > > > -- > -- > > Rushabh Lathia > Database Architect > EnterpriseDB Corporation > The Enterprise Postgres Company > > Phone: +91-20-30589494 > > Website: http://www.enterprisedb.com > EnterpriseDB Blog: http://blogs.enterprisedb.com/ > Follow us on Twitter: http://www.twitter.com/enterprisedb > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --000000000000f2135e056e95dd6b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Rushabh - patch applied!

On Thu, Jun 14, 2018 at 5:49 AM, Rusha= bh Lathia <rushabh.lathia@enterprisedb.com> wr= ote:
Thanks Ashesh and Dave.

I verified the changes and it lo= oks good to me.=C2=A0 I found that newly
added unpackaged file sti= ll have old file header comment.=C2=A0 Which
require change with n= ew file name.

PFA patch to fix the same.

Thanks,<= br>

On Wed, Jun 13, 2018 at 6:10 PM, Dave Page <dpage@pgadm= in.org> wrote:
Thanks, applied.

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

As per my conversation with Rushabh, we need to re= name 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 fin= d the attached patch for the same.

--

= Thanks & Regards,

Ashesh Vashi
Enterpr= iseDB 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.blogspot.com
Twitter: @pg= snake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL C= ompany



--
--
Rushabh Lathia
Database Architect
=
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: +=
91-20-30589494

Website: http://www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterpr=
isedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb=




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

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