[pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Piotr Czekalski
I've installed the PgAgent over PostgreSQL 8.4.2(already running for few months), on Fedora 12 (x64) OS. The DB by itself works perfect. The script was taken from the Fedora's distro, running: ./psql -h -d postgres --user postgres -f /usr/local/pgadmin3/share/pgadmin3/pgagent.sql and returned n

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Thom Brown
On 15 November 2010 13:09, Piotr Czekalski wrote: > I've installed the PgAgent over PostgreSQL 8.4.2(already running for few > months), on Fedora 12 (x64) OS. The DB by itself works perfect. The script > was taken from the Fedora's distro, running: > ./psql -h -d postgres --user postgres -f > /u

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Dave Page
On Mon, Nov 15, 2010 at 1:09 PM, Piotr Czekalski wrote: > I've installed the PgAgent over PostgreSQL 8.4.2(already running for few > months), on Fedora 12 (x64) OS. The DB by itself works perfect. The script > was taken from the Fedora's distro, running: > ./psql -h -d postgres --user postgres -f

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Piotr Czekalski
Have you got the jobs node enabled? This is done by going to File > Options > Browser and ticking the "pgAgent Jobs" option. Yes, the checkbox is marked (is on). Regards, Piotr

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Dave Page
On Mon, Nov 15, 2010 at 4:52 PM, Piotr Czekalski wrote: > W dniu 2010-11-15 14:46, Dave Page pisze: >> >> On Mon, Nov 15, 2010 at 1:09 PM, Piotr Czekalski >>  wrote: >>> >>> I've installed the PgAgent over PostgreSQL 8.4.2(already running for few >>> months), on Fedora 12 (x64) OS. The DB by itsel

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Piotr Czekalski
W dniu 2010-11-15 14:46, Dave Page pisze: On Mon, Nov 15, 2010 at 1:09 PM, Piotr Czekalski wrote: I've installed the PgAgent over PostgreSQL 8.4.2(already running for few months), on Fedora 12 (x64) OS. The DB by itself works perfect. The script was taken from the Fedora's distro, running: ./ps

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Piotr Czekalski
David, Thom, Problem is solved right now (just a minute ago) - the real reason seems to be multilanguage support of PgAdmin. Im using Polish (actually 'default') language version according to the OS settings and have just switched to English language for a while to ensure the options you've wr

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Thom Brown
On 15 November 2010 17:15, Piotr Czekalski wrote: > David, > Thom, > > Problem is solved right now (just a minute ago) - the real reason seems to > be multilanguage support of PgAdmin. > Im using Polish (actually 'default') language version according to the OS > settings and have just switched to

Re: [pgadmin-support] PGAdmin - still no jobs node.

2010-11-15 Thread Dave Page
On Mon, Nov 15, 2010 at 5:19 PM, Thom Brown wrote: > > I'm also using 1.12.1 but don't have that problem. (see attached image) > I too see the Zadania node if I run in Polish (on OSX). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.c

[pgadmin-support] orphaned runaway queries after killing pgadmin

2010-11-15 Thread Dan Halbert
Today I end up killing pgadmin a few times while inadvertantly running some huge queries and some ALTER requests that were blocked due to the queries. I should have canceled the queries from pgadmin, but I didn't. When I saw that the postgres processes were using up 100% of the CPU, I looked up

Re: [pgadmin-support] orphaned runaway queries after killing pgadmin

2010-11-15 Thread Guillaume Lelarge
Le 15/11/2010 21:10, Dan Halbert a écrit : > Today I end up killing pgadmin a few times while inadvertantly > running some huge queries and some ALTER requests that were blocked > due to the queries. I should have canceled the queries from pgadmin, > but I didn't. When I saw that the postgres proce