Re: [GENERAL] Pgagent

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 wro

Re: [GENERAL] Pgagent

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 funct

Re: [GENERAL] Pgagent

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 succ

Re: [GENERAL] Pgagent

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.

Re: [GENERAL] pgAgent

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

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

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

Re: [GENERAL] PgAgent binary distribution for Centos 6.5

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

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

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 >

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

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 s

Re: [GENERAL] pgagent on a mac

> --- 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 r

Re: [GENERAL] pgAgent Crash on WinXP

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

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 5

Re: [GENERAL] PgAgent

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

Re: [GENERAL] PgAgent

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 Postgre

Re: [GENERAL] PgAgent

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

Re: [GENERAL] PgAgent logging verbosity

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 lot

Re: [GENERAL] pgagent install on windows

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

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