Hi,
in stepsdefinition-
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
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.?
Any Help..
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
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 http://pgagent.in definition section can
i select SQL or BATCH ..?
or else any other method.?
See here:
On 04/13/2015 07:22 AM, Ramesh T wrote:
Hi,
in stepsdefinition-
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
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
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
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
http://postgresql.nabble.com/file/n5834094/pic1.png
I have created a job using pgagent as follows:
http://postgresql.nabble.com/file/n5834094/pic1.png
http://postgresql.nabble.com/file/n5834094/pic2.png
http://postgresql.nabble.com/file/n5834094/pic3.png
http://postgresql.nabble.com/file/n5834094/pic4.png
But when I am running the job I am
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:
hi, guys
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.
many thanks
--
Disclaimer : This E-mail is intended only for the use of the individual or
entity named above and may
how can i install pgAgent in postgresql 8.4 if mi internet conection don't
allow to any program to conect internet.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgAgent-tp5808135.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent
Dear Sir/Madam,
PgAgent is failing to start, giving an Error 1053: The service did not
respond to the start or control request in a timely fashion on a Windows
2008 R2 server.
I can run pgagent no problems in DEBUG mode. I have un-installed and
re-installed PgAgent multiple times. I have
Hi,
I'm attempting to install pgagent on SLES 11. So far I have downloaded the
pgagent (3.3.0) to the server. Extracted using gunzip and untarred.
I had the sysadmin install cmake 2.6 wxGTK wxGTK-devel using yast. When
i run wx-config it shows version 2.8.10
When i attempt to install pgagent I
We recently recompiled pgAgent 3.3.0 for our Centos x86 64 environment
to over come the problem of steps with a non-zero result codes being
reported as successful.
What appears to be happening is if the first step has a non-zero result
then it correctly has the status of Failed but if it is a
Hi,
I have successfully installed pgagent and scheduled the pgagent job in
pgadmin (on both windows and linux - ubunut 10.04). However, i experience
two different behaviors in windows and linux (none of which is expected and
correct).
The job is the simple insert SQL statement (for testing).
Hi.
I can't set proper encoding for pgAgent.
I have two databases: postgres and www.
postgres is encoded in UTF8, www is encoded in WIN1250.
When i run pgAgent's task in www database, it fail (message char cant
be converted to UTF8):
2011-10-27 14:50:29 CEST [nieznany] 1.COPY
BŁĄD:
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:
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
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 adrian.kla...@gmail.comwrote:
On Friday, March 18, 2011 12:36:07 pm akp geek wrote:
hi all -
I am trying to install the pgagent on
Dear all,
I installed PgAgent and started its service and successfully scheduled a
backup and got 100% result. Now the same Job is not working even I reinstalled
PgAgent but failed to get result.
Regards,
Abdul Rehman.
--- 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
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
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
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
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
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 ?
Regards
Ezequias
---(end of
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
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
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 ?
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.
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use
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
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
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
Thanks Dave, you were correct - pgadmin was connecting to template1.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
35 matches
Mail list logo