On Thu, 4 Jun 2009 10:35:03 +0100,
Dave Page wrote:
> On Wed, Jun 3, 2009 at 9:03 PM, Seb wrote:
>> Great, I can see the Jobs node now using my normal user account.
>> However, right-clicking on the jobs doesn't present an option to
>> create new jobs; it only shows "_Object list report" and "_R
On Wed, Jun 3, 2009 at 9:03 PM, Seb wrote:
> Great, I can see the Jobs node now using my normal user account.
> However, right-clicking on the jobs doesn't present an option to create
> new jobs; it only shows "_Object list report" and "_Run now" options
> under "Refresh" in the context menu. An
On Wed, 3 Jun 2009 20:40:26 +0100,
Dave Page wrote:
> On Wed, Jun 3, 2009 at 8:32 PM, Seb wrote:
>>> It may be easier to drop the schema altogether, grant your user
>>> account access to the postgres database, and then re-create the
>>> pgagent schema using your user account.
>> Yes, this sound
On Wed, Jun 3, 2009 at 8:32 PM, Seb wrote:
>> It may be easier to drop the schema altogether, grant your user
>> account access to the postgres database, and then re-create the
>> pgagent schema using your user account.
>
> Yes, this sounds simpler at this point, although I'm not sure what
> priv
On Wed, 3 Jun 2009 19:30:11 +0100,
Dave Page wrote:
> Seb; please keep the list CC'd - even if it takes a while to get
> through it'll save me having to keep re-adding it.
Strange, I didn't remove the list (I simply kept you cc'd) -- on-list
only here!
> More inline...
> On Wed, Jun 3, 2009 a
Seb; please keep the list CC'd - even if it takes a while to get
through it'll save me having to keep re-adding it.
More inline...
On Wed, Jun 3, 2009 at 5:42 PM, Seb wrote:
>> Unfortunately you didn't show the psql prompt when you ran the query
>> using your normal user account, but I'll bet yo
On Wed, 3 Jun 2009 17:24:00 +0100,
Dave Page wrote:
> On Wed, Jun 3, 2009 at 5:05 PM, Seb wrote:
>> It would also be interesting to see the results of those two queries
>>> run by hand:
>>> SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON
>>> ns.oid=relnamespace WHERE relname='pga_job' AN
On Wed, Jun 3, 2009 at 5:05 PM, Seb wrote:
> It would also be interesting to see the results of those two queries
>> run by hand:
>
>> SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON
>> ns.oid=relnamespace WHERE relname='pga_job' AND nspname='pgagent';
>
>> SELECT has_schema_privilege('pga
On Wed, Jun 3, 2009 at 3:36 PM, Seb wrote:
> I've resent my follow-up to the ng several times during the last 2 days,
> but some filter must be rejecting it, so am replying off-list.
> Hopefully this will make it here (thanks for having a look!):
Strange. The output from netstat looks reasonable
On Mon, Jun 1, 2009 at 4:08 PM, Seb wrote:
> Thanks again. I have a single cluster, so no chance it's a different
> cluster. The only thing I can think of is that long ago the system was
> Debian "testing", and when it was upgraded to sid it switched to using
> port 5433. Could that be a probl
On Mon, 1 Jun 2009 08:52:25 +0100,
Dave Page wrote:
> On Sat, May 30, 2009 at 11:31 PM, Seb wrote:
>>> Is pgAdmin connecting to the postgres database by default (ie. it's
>>> listed as the maintenance DB on the server properties dialogue)? Did
>>> you close and restart pgAdmin after running the
On Sat, May 30, 2009 at 11:31 PM, Seb wrote:
>> Is pgAdmin connecting to the postgres database by default (ie. it's
>> listed as the maintenance DB on the server properties dialogue)? Did
>> you close and restart pgAdmin after running the SQL script?
>
> Thanks Dave, yes, postgres is listed as the
On Sat, 30 May 2009 23:23:57 +0100,
Dave Page wrote:
> On Sat, May 30, 2009 at 10:49 PM, Seb wrote:
>> Hi,
>> I've followed the instructions to get pgagent up and running in
>> Debian sid. However, I do not see the "Jobs" node in
>> pgadmin. Here's what I did:
>> su postgres [PASSWORD] psql
On Sat, May 30, 2009 at 10:49 PM, Seb wrote:
> Hi,
>
> I've followed the instructions to get pgagent up and running in Debian
> sid. However, I do not see the "Jobs" node in pgadmin. Here's what I
> did:
>
> su postgres
> [PASSWORD]
> psql -d postgres < /usr/share/pgadmin3/pgagent.sql
>
> which
Hi,
I've followed the instructions to get pgagent up and running in Debian
sid. However, I do not see the "Jobs" node in pgadmin. Here's what I
did:
su postgres
[PASSWORD]
psql -d postgres < /usr/share/pgadmin3/pgagent.sql
which ran successfully, AFAICT. Is there anything else that should be
15 matches
Mail list logo
