While playing around with pgadmin to see the state of running queries, I
noticed that all of the queries are falling under the category of "slow
processes" or "idle process". Some of the process whose query is
showing as idle are tagged as idle processes, while some are tagged as
slow processes.
Thanks!
That pointed me in the right direction. The ex-config had a different
name (with versioning in it), so I simply created a symlink to it and
that fixed it. Also had to turn off static build, but it all appears to
have worked.
Thank you so much for your assistance!
--
Sent via pgadmin-su
4 PM
> To: Benjamin Krajmalnik
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Compiling pgAgent on FreeBSD 8
>
> On Fri, Apr 23, 2010 at 7:04 PM, Benjamin Krajmalnik
> wrote:
> > As you may be aware, there is no longer a port for pgagent (which
> use
As you may be aware, there is no longer a port for pgagent (which used
to be part of the pgadmin port).
I am building a new box (FreeBSD 8) and having some issues compiling
pgagent from source.
I already installed pgadmin, so the wxwidgets are already installed.
These are the steps which I took
In pgAdmin, one can view the total disk size occupied by a table in the
statistics view when in the "Tables" context.
What query is being used to calculate this?
I have found pg_relation_size() but it has to be called for multiple
entities in order to arrive at the total utilization.
Thanks i
It appears that pgagent is missing from the FreeBSD port of pgAdmin3
1.10.0.
Can someone confirm this?
I just built a new test environment and unfortunately pgagent does not
appear to be installed when installing pgAdmin.
TIA
There is a bug on the php pg libraries for windows.
Apparently they are having an issue loading the libraries (started about
a year ago with an apparent change in the way the p libraries are
compiled)..
On my windows test installations I have had to downgrade to earlier
versions of PHP.
> -Ori
Dave,
If all that is required is the pgagent binary (single file) I can send it to
him since I have both x86 and amd64 versions running.
Just want to make sure I send him everything he needs.
> -Original Message-
> From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-
> ow..
Let's see - you say it's crap, everyone else likes it.
Heck, if you don't like it don't use it.
However, do take your bitching elsewhere.
This forums are for people who have a constructive attitude, which you
obviously don't.
So, if you feel you have some sort of entitlement to bitch, start your
ow
Via pgAdmin, going into the pgagent catalog, I do not have an option of
changing the column type to int4.
> -Original Message-
> From: Dave Page [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 06, 2008 4:57 AM
> To: Benjamin Krajmalnik
> Cc: pgadmin-support@postgresql.or
I have a scehduled job which randomizes a column inside a table.
The query is as follows:
update tbllocations set randsort=random();
Every time the job runs, it performs its task properly without any
issues, but I kept seeing the job as failed, and if you view the
statistics on the jon it shous
I just tried running the admin81.sql script directly on the
server via psql.
I ran it twice - these are the results from the second
run:
%psql postgres < admin81.sqlERROR: could not
access file "$libdir/admin81": No such file or directoryERROR: could
not access file "$libdir/admin81": No
I am having some
minor issues installing the instrumentation functions on
FreeBSD.
I copied th admin81
directory into the contrib folder and modified the Makefile to also read that
directory.
So far so good. I do
see admin81.so in /usr/local/pgsql/lib
I restarted
postgres.
I conncted f
I hae a set of tables which are quite large and which only have records
inserted into them.
The size of the tables (which are partitioned tables) reach 2-3GB (data
only) plus indices.
I decided to exclude them from the auto-vacuum process, since I
identified that I was having performance issues wh
Message-From: Dave Page
[mailto:[EMAIL PROTECTED]Sent: Thursday, April 20, 2006 1:10
PMTo: Benjamin Krajmalnik;
pgadmin-support@postgresql.orgSubject: RE: [pgadmin-support] pgAgent
question
That looks straightforward
enough - how quickly does it run in psql? That uses PQexec like pgAgent
= myrecord.testguid and
tblkstests.testid = myrecord.testid ; close
mycursor; END LOOP; -- select
startdate; return startdate;END;$BODY$ LANGUAGE
'plpgsql' VOLATILE;
From: Dave Page
[mailto:[EMAIL PROTECTED]Sent: Thu 4/20/2006 9:35
AMTo: Benjamin Krajmalnik;
pgadmin-support@postgresql
: Benjamin KrajmalnikCc:
pgadmin-support@postgresql.orgSubject: RE: pgAgent
question
> -Original Message-> From: Benjamin
Krajmalnik [mailto:[EMAIL PROTECTED]]> Sent: 19
April 2006 20:23> To: Dave Page> Subject: pgAgent
question>> Hi Dave,>> I have a quick
I am having problems with pgAgent.
I installed the seervice with the following
command:
C:\Program Files\PostgreSQL\8.1\bin>"C:\Program
Files\PostgreSQL\8.1\bin\pgAgent" INSTALL pgAgent -u postgres -p postgres -t 60
hostaddr=127.0.0.1 dbname=postgres user=postgres
In the services, the path t
18 matches
Mail list logo
