How to install pgAgent on windows for postresql-bigsql-10.5

Hi

On Thu, Sep 6, 2018 at 6:23 AM, jimmy <mpokky@126.com> wrote:

I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database.
How to install pgAgent on windows for postresql-bigsql-10.5.
I have been searching some articles to install pgAgent.
But they do not work.
I found there has not any version of pgAgent for windows in the website '
www.pgadmin.org'.
And PostgreSQL-10.5-1-win64-bigsql.exe installer also has not the pgAgent.
When I execute CREATE EXTENSION pgagent, it throws ERROR: could not open
extension control file
"H:/PostgreSQL/pg10/../pg10/share/postgresql/extension/pgagent.control":
No such file or directory.
How can I resolve these problems.
Thank you.

If you use the EDB PostgreSQL installers, you can install pgAgent using
StackBuilder. For BigSQL you'll probably have to build and install it
manually from source (which isn't exactly easy on Windows, and is dependent
on what is included with and how BigSQL is packaged - which I know nothing
about).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Is EnterpriseDB opensource and free. Has this database some limits and restrictions ?

At 2018-09-06 15:57:30, "Dave Page" <dpage@pgadmin.org> wrote:

Hi

On Thu, Sep 6, 2018 at 6:23 AM, jimmy <mpokky@126.com> wrote:

I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database.
How to install pgAgent on windows for postresql-bigsql-10.5.
I have been searching some articles to install pgAgent.
But they do not work.
I found there has not any version of pgAgent for windows in the website 'www.pgadmin.org'.
And PostgreSQL-10.5-1-win64-bigsql.exe installer also has not the pgAgent.
When I execute CREATE EXTENSION pgagent, it throws ERROR: could not open extension control file
"H:/PostgreSQL/pg10/../pg10/share/postgresql/extension/pgagent.control": No such file or directory.
How can I resolve these problems.
Thank you.

If you use the EDB PostgreSQL installers, you can install pgAgent using StackBuilder. For BigSQL you'll probably have to build and install it manually from source (which isn't exactly easy on Windows, and is dependent on what is included with and how BigSQL is packaged - which I know nothing about).

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, Sep 6, 2018 at 9:41 AM, jimmy <mpokky@126.com> wrote:

Is EnterpriseDB opensource and free. Has this database some limits and
restrictions ?

The EDB PostgreSQL installers are free, opensource and have no limits or
restrictions. They are the very first option at
https://www.postgresql.org/download/windows/

At 2018-09-06 15:57:30, "Dave Page" <dpage@pgadmin.org> wrote:

Hi

On Thu, Sep 6, 2018 at 6:23 AM, jimmy <mpokky@126.com> wrote:

I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database.
How to install pgAgent on windows for postresql-bigsql-10.5.
I have been searching some articles to install pgAgent.
But they do not work.
I found there has not any version of pgAgent for windows in the website '
www.pgadmin.org'.
And PostgreSQL-10.5-1-win64-bigsql.exe installer also has not the
pgAgent.
When I execute CREATE EXTENSION pgagent, it throws ERROR: could not open
extension control file
"H:/PostgreSQL/pg10/../pg10/share/postgresql/extension/pgagent.control":
No such file or directory.
How can I resolve these problems.
Thank you.

If you use the EDB PostgreSQL installers, you can install pgAgent using
StackBuilder. For BigSQL you'll probably have to build and install it
manually from source (which isn't exactly easy on Windows, and is dependent
on what is included with and how BigSQL is packaged - which I know nothing
about).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

For BigSQL you'll probably have to build and install it manually from

source (which isn't exactly easy > on Windows, and is dependent on what is
included with and how BigSQL is packaged - which I know > nothing about).

Another option is using jpgAgent: https://github.com/GoSimpleLLC/jpgAgent

You'd still install the Postgres part of the extension like normal (so it
creates the pgagent schema / tables / functions), but you can then use the
agent above as a drop in replacement for the original, while enjoying the
extra features and stability.

Has jpgAgent UI interface to be operated?

At 2018-09-06 23:57:23, "Adam Brusselback" <adambrusselback@gmail.com> wrote:

For BigSQL you'll probably have to build and install it manually from source (which isn't exactly easy > on Windows, and is dependent on what is included with and how BigSQL is packaged - which I know > nothing about).

Another option is using jpgAgent: https://github.com/GoSimpleLLC/jpgAgent

You'd still install the Postgres part of the extension like normal (so it creates the pgagent schema / tables / functions), but you can then use the agent above as a drop in replacement for the original, while enjoying the extra features and stability.

Has jpgAgent UI interface to be operated?

The same UI that works with standard pgagent works just as well for
jpgAgent. So PGAdmin 3 or 4 will work just fine.

It was designed to be a drop in replacement for the agent portion of
pgagent, while able to use the same database tables and UI.