I'm trying to install pgagent in a windows environment. Postgresql version 9.6 is installed and application stack builder was installed with it. I have followed the steps, detailed here.
The first step in this guide is to create the extension in the…
I have installed PostgreSQL 9.6 in win 10.
Also installed pgAgent for job scheduling.
I have create one job for batch file execute but it showing status 'r','i'.
What is the meaning of status field.
I have attached screenshot.
image link1
image…
I have downloaded separately pgagent 3.4.1 & pgAdmin 4. I want to create jobs from inside pgAdmin like explained https://www.openscg.com/bigsql/docs/pgadmin4/pgagent_install.html but when I execute the command I get the error :
ERROR: could not…
I installed pgagent on Ubuntu 16.04.
I executed:
CREATE EXTENSION pgagent;
CREATE LANGUAGE plpgsql;
According this: https://www.pgadmin.org/docs/pgadmin4/1.x/pgagent_install.htm
I ran
/usr/bin/pgagent hostaddr=127.0.0.1 user=my_user…
I've installed pgAgent with the Windows service using a local machine account called postgres. I have confirmed that the Windows service is running normally. I created a job in pgAdmin that should delete certain records from a table in my customer…
I'm new in PostgreSQL, and I want to create a scheduled job which is run every day.
Firstly I'm creating a function for this. my function is working fine.
And now I want to create jobs and use this function inside the jobs, so it runs every day.
But…
.pgpass seems to be not working. Could you check my pgagent setting?
OS : centos 7 ( I did NOT disable selinux )
Database : postgresql 9.6.5
pgagent : pgagent_96 3.4.0-9.rhel7 ( installed package using yum )
I logged on centos server as user…
I am using PostgreSQL version 9.3 for Operating system window 7.
I am getting problem to display the option jobs in postgresql PgAdmin III.
Here are the pictures what I have tried:
After setting pgAgent Jobs checked I restart the server and…
I've looked at the documentation online but i cant find the 'pgagent.sql' script anywhere on my system. These are the instructions i'm following here. Can i download it from anywhere else?
I am using PostgreSQL Database, I am running a Database Server .
My PostgreSQL Version is :
postgres=# select version();
version
-------------------------------------------------------------
PostgreSQL 9.2.4, compiled by…
The Jobs category shown in the pgAdmin seems to be only visible for the super user accounts.(see the screen below) . When I use the non super user accounts to login , I cannot see the jobs category.Is it possible to configure such that a non super…
I am new to PG Admin. I need to set up a pg agent job to refresh the materialized views. I created a job following the documents but I don't understand whether its working not. Is there any way to find out whether the job is running or not?
