Thread: [PGAGENT] Upgrade pgAgent from unpackaged version

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

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

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 <dpage@pgadmin.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 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