[PGAGENT] Upgrade pgAgent from unpackaged version

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[PGAGENT] Upgrade pgAgent from unpackaged version

Ashesh Vashi
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


pgagent_extension_from_unpackaged.sql (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [PGAGENT] Upgrade pgAgent from unpackaged version

Dave Page-7
Thanks, applied.

On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: [PGAGENT] Upgrade pgAgent from unpackaged version

rushabh-2
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 <[hidden email]> wrote:
Thanks, applied.

On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi <[hidden email]> 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


unpackaged_file_header_change.patch (726 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [PGAGENT] Upgrade pgAgent from unpackaged version

Dave Page-7
Thanks Rushabh - patch applied!

On Thu, Jun 14, 2018 at 5:49 AM, Rushabh Lathia <[hidden email]> 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 <[hidden email]> wrote:
Thanks, applied.

On Wed, Jun 13, 2018 at 5:11 AM, Ashesh Vashi <[hidden email]> 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