How does one copy PG Agent jobs from one cluster to another? Ideally I would
like to do so in some controlled way- i.e. task "Cleanup Historical Invoices"
is ready to be released from dev to production. Need to be able to give the DBA
performing the release some SQL they can run. There does not
How does one deal with transactions in PGAgent jobs? I have many scenarios
where I will loop through a set of data, run a function on each, and commit
whatever succeeds or rollback whatever fails. In Oracle, I was doing this with
pl/sql scripts run via sqlplus and cron. In Postgres, I set them u
-Original Message-
From: Dave Page [mailto:dp...@pgadmin.org]
Sent: Tuesday, August 13, 2013 4:13 AM
To: David Greco
Cc: PgAdmin Support (pgadmin-support@postgresql.org)
Subject: Re: [pgadmin-support] PGAgent runs all jobs on startup
On Mon, Aug 12, 2013 at 7:35 PM, David Greco
wrote
I have about 20 jobs scheduled via PGAgent to run at various times. Some daily,
some every X minutes, some at certain times, etc. I just started pgagent on the
server and noticed it ran all my jobs upon startup, despite it not being a
scheduled time. Is this an option somewhere I'm missing?
Found it, they appear under the Foreign Data Wrapper in the object browser
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of David Greco
Sent: Thursday, September 27, 2012 9:01 AM
To: PgAdmin Support (pgadmin-support@postgresql.org)
Subject
Where should Foreign Servers appear in the Object Browser? I have two foreign
servers defined, confirmed by querying information_schema.foreign_servers, but
the Object Browser doesn't show them in the schema they are defined, or any
other place that I can see. I have Foreign Servers checked in
All the time, on any function, an on all the servers I have
On Mar 18, 2012, at 5:56 AM, "Guillaume Lelarge" wrote:
> Le 12/03/2012 18:05, David Greco a écrit :
>> pgAdmin 1.14.2 connected to PostgreSQL 9.1.2 on 64-bit linux running
>> edb-debugger version .93.
>>
Let me voice my agreement for this as a feature sorely missing from pgAdmin.
Should be able to do full code completion of column names (aliased or not table
names), function names (type schema. and functions should be available as a
completion), and function paramaters (type functioname( and it
