Re: [GENERAL] Pgagent

[Ramesh T]

no error messages.. i checked at PostgreSQL\9.4\data\pg_log

Didn't deleted data from table.after schedule time..

one thing i don't understand ,after set timings and in definition section
also the function works fine individually.

any help..




On Mon, Apr 13, 2015 at 8:47 PM, Adrian Klaver 
wrote:

> On 04/13/2015 07:22 AM, Ramesh T wrote:
>
>> Hi,
>> in steps>definition->
>> do
>> $body$
>> begin
>> perform delete_empty_parts();
>> end;
>> $body$
>>
>> delete_empty_parts is the function
>>
>> i do selected SQL option in step process.Right clicked on job chosen run
>> now it getting failed(On error i selected failed,if select success it
>> getting success)
>>
>
> Is there an error message in the Postgres logs?
>
>
>> I'm running function on particular database and selected today dates..
>>
>> but function wasn't executed.
>>
>
> How do you know?
>
>
>> let me know how to set it function in pgagent..
>>
>> On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver
>> mailto:adrian.kla...@aklaver.com>> wrote:
>>
>> On 04/13/2015 06:53 AM, Ramesh T wrote:
>>
>> Hi all,
>>i have a function to delete data from table.Where i
>> need to
>> place function in pgagent.in 
>>  definition section can
>> i select SQL or BATCH ..?
>>
>> or else any other method.?
>>
>>
>> See here:
>>
>> http://www.pgadmin.org/docs/__dev/pgagent.html
>> 
>>
>> Any Help..
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com 
>>
>>
>>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Re: [GENERAL] Pgagent

[Ramesh T]

Hi,
in steps>definition->
do
$body$
begin
perform delete_empty_parts();
end;
$body$

delete_empty_parts is the function

i do selected SQL option in step process.Right clicked on job chosen run
now it getting failed(On error i selected failed,if select success it
getting success)

I'm running function on particular database and selected today dates..

but function wasn't executed.

let me know how to set it function in pgagent..

On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver 
wrote:

> On 04/13/2015 06:53 AM, Ramesh T wrote:
>
>> Hi all,
>>   i have a function to delete data from table.Where i need to
>> place function in pgagent.in  definition section can
>> i select SQL or BATCH ..?
>>
>> or else any other method.?
>>
>
> See here:
>
> http://www.pgadmin.org/docs/dev/pgagent.html
>
>  Any Help..
>>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Re: [GENERAL] Pgagent

[Adrian Klaver]

On 04/13/2015 07:22 AM, Ramesh T wrote:

Hi,
in steps>definition->
do
$body$
begin
perform delete_empty_parts();
end;
$body$

delete_empty_parts is the function

i do selected SQL option in step process.Right clicked on job chosen run
now it getting failed(On error i selected failed,if select success it
getting success)


Is there an error message in the Postgres logs?



I'm running function on particular database and selected today dates..

but function wasn't executed.


How do you know?



let me know how to set it function in pgagent..

On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:

On 04/13/2015 06:53 AM, Ramesh T wrote:

Hi all,
   i have a function to delete data from table.Where i
need to
place function in pgagent.in 
 definition section can
i select SQL or BATCH ..?

or else any other method.?


See here:

http://www.pgadmin.org/docs/__dev/pgagent.html


Any Help..



--
Adrian Klaver
adrian.kla...@aklaver.com 





--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Pgagent

[Adrian Klaver]

On 04/13/2015 06:53 AM, Ramesh T wrote:

Hi all,
  i have a function to delete data from table.Where i need to
place function in pgagent.in  definition section can
i select SQL or BATCH ..?

or else any other method.?


See here:

http://www.pgadmin.org/docs/dev/pgagent.html


Any Help..



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgAgent

[Adam Brusselback]

Here you are:

do $$
declare
job_id int;
begin

/* add a job and get its id: */
insert into
pgagent.pga_job (
jobjclid
, jobname
)
values
(
1 /*1=Routine Maintenance*/
, 'DELETE_NAMES' /* job name */
)
returning
jobid
into
job_id;


/* add a step to the job: */
insert into
pgagent.pga_jobstep (jstjobid, jstname, jstkind, jstcode,
jstdbname)
values
(
job_id
, 'DELETE_NAMES' /* step name */
, 's'/* sql step */
, 'BEGIN DELETE_NAMES; END;'  /* the sql to run */
, 'somedatabase'  /* the name of the database
to run the step against */
);


/* add a schedule to the job. This one runs every day at midnight: */
insert into pgagent.pga_schedule (
jscjobid
, jscname
, jscdesc
, jscminutes
, jschours
, jscweekdays
, jscmonthdays
, jscmonths
, jscenabled
, jscstart
, jscend)
values(
job_id
, 'schedule name'
, ''
,
'{t,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'
, '{t,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'
, '{f,f,f,f,f,f,f}'
, '{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}'
, '{f,f,f,f,f,f,f,f,f,f,f,f}'
, true
, '2015-04-06 00:00:00'
, NULL
);


end $$;


On Thu, Apr 2, 2015 at 12:25 PM, Champion Always  wrote:

> Hi,
>job_name => 'DELETE_NAMES'
>  ,job_type => 'PLSQL_BLOCK'
>  ,job_action => 'BEGIN DELETE_NAMES; END;'
>  ,start_date => sysdate
>  ,repeat_interval => 'FREQ=DAILY'
>  ,enabled => TRUE);
> it is oracle ..
>
> .And i installed pgAgent On postgres ..
> how  above oracle code can convert to postgres and place it in pgagent for
> daily schedule
> any help..?
>

Re: [GENERAL] pgagent jobs Could not connect to the database !

[Adrian Klaver]

On 01/15/2015 08:07 AM, sambsa wrote:

I have created a job using pgagent as follows:


Did you install the pgAgent daemon/service?:

http://www.pgadmin.org/docs/dev/pgagent-install.html#daemon-installation-on-unix








But when I am running the job I am getting error as follows:



Error is like the following:

Could not connect to the database !

Please help me guys. How can I solve this??



--
View this message in context: 
http://postgresql.nabble.com/pgagent-jobs-Could-not-connect-to-the-database-tp5834094.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.





--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PgAgent binary distribution for Centos 6.5

[Devrim Gündüz]

Hi,

On Mon, 2014-08-11 at 19:33 +0800, Jen Sing Choe wrote:
> does anyone have link to download pgagent binary distribution for centos ?
> i tried on building the tar source but stuck on resolving the wxGTK
> (wxWidget) dependencies.

I pushed pgagent 3.4.0 RPMs to PostgreSQL RPM repo today:
http://yum.postgresql.org

Regards,


-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR



signature.asc
Description: This is a digitally signed message part

Re: [GENERAL] pgagent installation -- ccmake - getting selected wxWidgets configuration (version: 2.6, debug: no, static

[akp geek]

thank you for the clues. I am downloading the package and will install and
update you

Regards

On Fri, Mar 18, 2011 at 4:45 PM, Adrian Klaver wrote:

> On Friday, March 18, 2011 12:36:07 pm akp geek wrote:
> > hi all -
> >
> >  I am trying to install the pgagent on solaris. when I do the
> > ccmake /opt/postgres/apps/pgAgent-3.0.1-Source, I am getting the
> following
> > error.
> >
> >  CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
> >The selected wxWidgets configuration (version: 2.6, debug: no, static:
> > yes,
> >unicode: yes, modules: base) is not available.
> >  Call Stack (most recent call first):
> >CMakeLists.txt:91 (FIND_PACKAGE)
>
> At a guess you do not have the wxWidgets dev package installed.
>
> >
> >
> > thanks for the help
> >
> > Regards
>
>
> --
> Adrian Klaver
> adrian.kla...@gmail.com
>

Re: [GENERAL] pgagent installation -- ccmake - getting selected wxWidgets configuration (version: 2.6, debug: no, static

[Adrian Klaver]

On Friday, March 18, 2011 12:36:07 pm akp geek wrote:
> hi all -
> 
>  I am trying to install the pgagent on solaris. when I do the
> ccmake /opt/postgres/apps/pgAgent-3.0.1-Source, I am getting the following
> error.
> 
>  CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
>The selected wxWidgets configuration (version: 2.6, debug: no, static:
> yes,
>unicode: yes, modules: base) is not available.
>  Call Stack (most recent call first):
>CMakeLists.txt:91 (FIND_PACKAGE)

At a guess you do not have the wxWidgets dev package installed.

> 
> 
> thanks for the help
> 
> Regards


-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgagent on a mac

[Dave Page]

> --- Original Message ---
> From: "kelvan" <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 07/12/07, 22:58:38
> Subject: [GENERAL] pgagent on a mac
> 
> now i want you all to trust me it was not my and never woudl be my choice to 
> use a mac server but i need pgagent to run on said mac server i have the 
> client side stuff running meaning i can create jobs but i need to know were 
> the daemon for the mac is so i can have it installed so my jobs will run i 
> haev looked around but i cannot seem to find one can any one help

It might be tucked away in the app bundle (can't check right now I'm afraid) - 
if not, you'll need to build from source unfortunately.

Regards, Dave

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [GENERAL] pgAgent Crash on WinXP

[Howard Cole]

Dave Page wrote:


Please try v1.6.3 - there was a bug fixed that might well cause this 
crash.


Regards, Dave.


Thanks Dave. I think that has fixed it.

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] pgAgent Crash on WinXP

[Dave Page]

Howard Cole wrote:

Hi,

I have recently started using the pgAgent and I am having some issues 
with the agent service crashing.


The job that I am running has two steps:

1. A vacuum.

2. Backup, which executes the following
"c:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p 
5432 -U postgres -F p -b -v --encoding=SQL_ASCII -f 
"d:\hq\backup\daily.backup" "hq"


Both steps appear to work, and the backup is created, and according to 
pgAdminIII, both steps are complete. However the status of the overall 
job is still "Running" according to pgAdmin, and the service has crashed.


This is the error that I get in the application log:

Faulting application pgAgent.exe, version 1.6.2.99, faulting module 
pgAgent.exe, version 1.6.2.99, fault address 0x50fd.


Please try v1.6.3 - there was a bug fixed that might well cause this crash.

Regards, Dave.

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] PgAgent

[Richard Huxton]

Ezequias R. da Rocha wrote:

Richard Huxton escreveu:

Ezequias R. da Rocha wrote:

Hello,

Has  someone noticed the problem of  installation  of contribs of 
postgreSQL 8.2.3.


I was looking for pgAgent and didn't noticed notting.

Has someone another alternative solution to install it  ?


It's part of pgAdmin, not PostgreSQL


So I must install pgAdmin on the server to have the pgAgent ?


Don't know - what does the pgAdmin documentation say about installing 
pgAgent?


--
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] PgAgent

[Ezequias R. da Rocha]

Richard Huxton escreveu:

Ezequias R. da Rocha wrote:

Hello,

Has  someone noticed the problem of  installation  of contribs of 
postgreSQL 8.2.3.


I was looking for pgAgent and didn't noticed notting.

Has someone another alternative solution to install it  ?


It's part of pgAdmin, not PostgreSQL


So I must install pgAdmin on the server to have the pgAgent ?

Ezequias

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] PgAgent

[Richard Huxton]

Ezequias R. da Rocha wrote:

Hello,

Has  someone noticed the problem of  installation  of contribs of 
postgreSQL 8.2.3.


I was looking for pgAgent and didn't noticed notting.

Has someone another alternative solution to install it  ?


It's part of pgAdmin, not PostgreSQL

--
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PgAgent logging verbosity

[Dave Page]

Ezequias Rodrigues da Rocha wrote:

Hi list,

I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent 
connection string it could spend much cpu processing.


I have other things running in the server and I don't like to create 
problem to others.


Please stop cross posting to lots of lists!

-l 2 is extremely unlikely to cause excessive CPU or IO, but it will 
clutter logs, so you wouldn't want to leave it on permanently.


Regards, Dave

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] pgagent install on windows

[Howard Cole]

Thanks Dave, you were correct - pgadmin was connecting to template1.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pgagent install on windows

[Dave Page]

Howard Cole wrote:
> Hi,
> 
> I have a few of problems installing the pgagent on windows, running
> version 8.2
> 
> 1. When I run the pgagent script on the postgres database, it seems to
> run and commit successfully, but when I view the schemas for the
> postgres database, there is no new schema for the pgagent. (is it hidden?)

It is by pgAdmin.

> 2. The new jobs node does not appear in pgadmin
> 
> 
> I have tried this on 8.2.1 and 8.2.3. I am getting regular output the
> application log with log level 2 so the agent appears to be running -
> its just that I cannot create any jobs?

pgAdmin will look for the pgAgent objects in the "Maintenance Database".
Check in your server properties that you are using postgres and not
template1 or some other database.

Regards, Dave.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/